oracle master

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...
English

Oracle Data Block Row Storage: Mechanism and Verification Steps

Introduction (Summary)In oracle, row storage inside a data block consists of “block header / directory / row data / free...
English

How to Use Oracle Managed Files (OMF): Complete Guide to Configuration, Procedures, and Operations

Introduction (Summary)Oracle Managed Files (OMF) is a mechanism that auto-names and auto-places data files, temp files, ...
Data Dictionary Internals_en

Oracle Move Data Files: Safe Procedures and Examples [Linux/19c]

When reorganizing storage or cleaning up directories in your Oracle environment, knowing how to move data files safely i...
Data Dictionary Internals_en

Oracle Tablespace View Complete Guide: Verify Usage Correctly with DBA_* / V$*

This article explains how to correctly verify the usage and size of tablespaces in Oracle and how to expand capacity whe...