| layout | default |
|---|---|
| title | DBA Tablespace Usage | Oracle EBS SQL Report |
| description | Tablespace usage including currently active undo and temp tablepace usage in Megabytes |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Tablespace, Usage, v$sort_segment, dba_tablespaces, v$parameter |
| permalink | /DBA%20Tablespace%20Usage/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Tablespace usage including currently active undo and temp tablepace usage in Megabytes
v$sort_segment, dba_tablespaces, v$parameter, dba_tablespace_usage_metrics, dba_data_files, dba_temp_files, dba_undo_extents
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
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.
| 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/ |
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.
- 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.
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.
- 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.
- 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