DBA Tablespace Usage – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Tablespace usage including currently active undo and temp tablepace usage in Megabytes
Report Parameters
Oracle EBS Tables Used
v$sort_segment, dba_tablespaces, v$parameter, dba_tablespace_usage_metrics, dba_data_files, dba_temp_files, dba_undo_extents
Report Categories
Related Reports
DBA SGA+PGA Memory Configuration, DBA AWR Tablespace Usage, DBA AWR Active Session History, DBA SGA Active Session History, DBA Blocking Sessions, DBA SGA Blocking Session Summary, DBA AWR Blocking Session Summary, DBA SGA Buffer Cache Object Usage, DBA AWR System Metrics Summary
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA Tablespace Usage 09-Mar-2021 101632.xlsx |
| Blitz Report™ XML Import | DBA_Tablespace_Usage.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-tablespace-usage/ |
Case Study & Technical Analysis
Abstract
The DBA Tablespace Usage report is the primary instrument for storage capacity planning and monitoring. It provides a unified view of space utilization across all types of tablespaces: Permanent (Data/Index), Temporary (Sort/Hash), and Undo (Rollback). By calculating the “Used” vs. “Allocated” vs. “Max Size” (autoextend), it gives a true picture of remaining capacity.
Technical Analysis
Core Logic
- Permanent Tablespaces: usage is calculated based on extent allocation in
DBA_DATA_FILES. - Temp Tablespaces: Usage is dynamic, based on
V$SORT_SEGMENTorDBA_TEMP_FILES. - Undo Tablespaces: Usage is based on active vs. expired extents in
DBA_UNDO_EXTENTS.
Key Views
DBA_TABLESPACE_USAGE_METRICS: A convenient view that pre-calculates usage percentages, accounting for auto-extensibility.DBA_DATA_FILES/DBA_TEMP_FILES: Physical file definitions.
Operational Use Cases
- Alerting: “Alert me when the
APPS_TS_TX_DATAtablespace is 90% full.” - Cleanup: Identifying tablespaces that are unexpectedly filling up due to unpurged interface tables.
- Undo Sizing: Monitoring if the Undo tablespace is large enough to support the
UNDO_RETENTIONperiod without “Snapshot too old” errors.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics