Space Management

Check RESUMABLE_TIMEOUT and RESUMABLE Status in V$SESSION Purpose V$SESSION carries two columns that tell you whether a session can survive running out of space: RESUMABLE and the resumable timeout that governs it. When resumable space allocation is enabled, a statement that hits a space error — a full tablespace, a …

Find the Biggest Files First When an Oracle Filesystem Fills Up Purpose A full Oracle filesystem is a five-alarm incident. Whether it is the /u01/oradata mount holding datafiles, the Fast Recovery Area filling with archive logs, or the diag directory overflowing with trace files, the first question is always the same: …

Monitor Oracle Data Pump Resumable Waits with DBA_RESUMABLE When you run a large Oracle Data Pump import (impdp), the job can fail mid-way if a tablespace runs out of space. Oracle's resumable import feature prevents this by suspending the job instead of failing it, giving you time to fix the problem and then letting …

Query to Display All Tablespaces Used by A Specified User and The Total Space Occupied (rounded to MB) A schema audit before a migration, a quota review before approving more space, or a tablespace consolidation project all start with the same question: which tablespaces does a specific Oracle user actually touch, and …

Identify Oracle Database Segments Nearing Their Maximum Extent Limit Oracle ignores the MAXEXTENTS storage parameter for objects in a locally managed tablespace, unless the tablespace has ALLOCATION_TYPE set to USER. That one rule decides whether the query below is useful on your database. It is a real early warning in …