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...
DBA
English English A Beginner’s Guide to SQL*Loader
SQL*Loader is an essential tool for efficiently loading large volumes of data into an Oracle database. This article prov...
English Explaining the ORA-1555 Error: Causes, Solutions, and Prevention
If you operate an Oracle database, you may have experienced the headache of the "ORA-1555: snapshot too old" error. This...
English Guide to UNDO Tablespaces and UNDO Segments
To properly operate an Oracle database, understanding the UNDO tablespace and UNDO segments is essential. This article i...
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 Oracle Net Configuration Guide
Oracle Net is the network service that connects databases and clients, and it is a critical mechanism for enabling remot...
English How to Write and Configure Oracle tnsnames.ora [A Beginner’s Guide]
Are you struggling with how to write or configure the tnsnames.ora file, which is essential for connecting to an Oracle ...
English Oracle Listener Monitoring and Performance Optimization
The Oracle Listener is a crucial component that manages connections between clients and the database. This article delve...
English The Oracle Listener: A Complete Guide from Basics to Best Practices
"Having trouble with smooth database connections?"Have you ever faced this problem? The key to solving it is the Oracle ...
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...
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...