English Explaining the Basics of the Oracle SELECT Statement
The SELECT statement is the most basic and important SQL statement for operating an Oracle database. It allows you to ex...
sql
English English Sample Tables and JOIN Examples for Hands-on Oracle Practice
When learning to operate an Oracle database, creating sample tables and manipulating data is extremely effective. This a...
English Explanation of Permanent Segments, UNDO Segments, and Temporary Segments
In an Oracle database, segments are essential components for storing data, managing transactions, and performing tempora...
English A Complete Explanation of Segment Shrink vs. DELETE/TRUNCATE Behavior
Efficient operation of Oracle Database requires freeing unnecessary space and optimizing performance. At the core of thi...
English Oracle Database Segment Extension — Error Handling and Best Practices
In Oracle Database, as data grows, segments can run short of space, which may trigger errors and degrade performance. Th...
English What Are Deferred Segments? Usage and Caveats
In Oracle Database, when you create a table, a segment (the physical storage area for data) is usually allocated immedia...
English Explaining Segment Management in Oracle Database
To improve the operational efficiency of a database, you need to optimize storage management. At the center of that is s...
Performance_en Oracle SQL Tuning Quick Guide: Execution Plans, Statistics, and Tracing [19c]
This article is a rewritten, more practical, and reproducible version of the original “Oracle SQL Tuning Basics.” While ...
English Row Migration & Row Chaining — Understand Causes, Detection, and Remedies in One Go (Oracle)
To solve database performance issues, you must understand row migration and row chaining. This article digs into both co...
English Segment Space Management Methods and PCTFREE Explained
Oracle Database administrators must correctly understand segment space management and the concept of PCTFREE to manage d...