English How to Handle Increased SYSAUX Tablespace Usage
1. What is the SYSAUX Tablespace?The SYSAUX tablespace is an auxiliary tablespace for the Oracle database, primarily use...
Tablespaces/Datafiles_en
English English How to Make Oracle Tables Read-Only and Move Them [ALTER TABLE]
In the operation of Oracle Database, there are frequent situations where you want to prevent accidental updates to maste...
26ai_en Oracle Smallfile vs Bigfile Differences and Best Practices: A DBA’s Operational Guide
In the physical design of an Oracle Database, the choice of tablespace management method directly impacts future scalabi...
26ai_en Oracle 26ai Tablespaces Default to Bigfile? Verification and Precautions
In Oracle Database 26ai (version 23.26.1 and later), the latest release for 2026, Oracle 26ai tablespaces are configured...
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 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...
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...
English Oracle Database 19c User Creation and Management
In this article, we will walk through how to create and manage a user in an oracle database, specifically assuming a non...
Bronze_en A Complete Guide to Creating Tables in Oracle Database [CREATE TABLE Explained]
Creating tables is one of the most fundamental skills when working with Oracle Database.This article provides a thorough...
Bronze_en Beginner’s Guide to Oracle Tablespaces
When you step into the world of Oracle databases, one of the first key concepts to understand is “Tablespaces.” This beg...
English Understanding the SYSTEM and SYSAUX Tablespaces in Oracle Database
Understanding SYSTEM and SYSAUX tablespaces is essential for proper Oracle Database administration. These are the “heart...