Tablespaces/Datafiles_en

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