Space-Management
Check RESUMABLE_TIMEOUT and RESUMABLE Status in V$SESSION
Jun 19, 2026 / · 6 min read · Oracle DBA V$SESSION Resumable Space Allocation Oracle Administration Session Management Space Management Oracle Performance Dynamic Performance Views ·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 …
Read MoreFind the Biggest Files First When an Oracle Filesystem Fills Up
May 16, 2026 / · 6 min read · Oracle Database Unix Commands Oracle DBA Filesystem Disk Management Troubleshooting Space Management ls du Commands ·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: …
Read Moreresumable_timeout and v$session: Monitor Oracle Resumable Jobs
Mar 4, 2026 / · 5 min read · oracle database data-pump impdp dba-resumable oracle-admin import-export space-management dba_resumable ·Oracle Resumable Import Parameters: Monitor and Manage 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 …
Read More