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...
sql
English 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...
English Oracle Tablespace Local Management: How to Create and Choose
Introduction (100–160 chars)In oracle 19c, creating a tablespace with local management automates extent management and s...
Database Design_en Oracle OS Authentication: Configuration Steps and Practical Points
Oracle Database provides two authentication methods: database authentication, which uses credentials managed inside the ...
English Oracle TNS_ADMIN: Proper Usage and Configuration Steps [Linux/19c]
Introduction (Summary)When you want to centrally manage Oracle connection settings, use the TNS_ADMIN environment variab...
English Oracle DBMS_PRIVILEGE_CAPTURE: Introduction to Privilege Analysis
To operate Oracle Database securely, it is important to grant users only the minimum required privileges. Leaving unnece...