| layout | default |
|---|---|
| title | DBA AWR Tablespace Usage | Oracle EBS SQL Report |
| description | Tablespace usage over time from the AWR – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Diagnostic Pack, Enginatics, DBA, AWR, Tablespace, Usage, v$parameter, v$database, dba_hist_tbspc_space_usage |
| permalink | /DBA%20AWR%20Tablespace%20Usage/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Tablespace usage over time from the AWR
Date From, Diagnostic Pack enabled, Container Data
v$parameter, v$database, dba_hist_tbspc_space_usage, ts$
DBA SGA+PGA Memory Configuration, DBA AWR System Metrics Summary, DBA Tablespace Usage, DBA AWR Active Session History, DBA AWR Settings, DBA Feature Usage Statistics, DBA AWR SQL Execution Plan History, DBA AWR SQL Performance Summary, DBA SGA Active Session History
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 AWR Tablespace Usage 18-Jan-2018 223607.xlsx |
| Blitz Report™ XML Import | DBA_AWR_Tablespace_Usage.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-awr-tablespace-usage/ |
The DBA AWR Tablespace Usage report tracks the historical growth of database storage. Unlike real-time checks that only show current usage, this report uses AWR history to show trends. This is essential for capacity planning, allowing DBAs to predict when a tablespace will fill up based on its growth rate over the last month or year.
- Capacity Planning: "When will we need to buy more disk storage?"
- Budgeting: "How much storage did the 'Archive' tablespace consume last year?"
- Anomaly Detection: "Why did the UNDO tablespace suddenly grow by 50GB yesterday?"
This report displays the used size of tablespaces over time.
Key Features:
- Used Space: The amount of space actually occupied by data.
- Allocated Space: The size of the datafiles.
- Growth Trend: By comparing snapshots, you can calculate the daily growth rate.
The report queries DBA_HIST_TBSPC_SPACE_USAGE.
Key Tables:
DBA_HIST_TBSPC_SPACE_USAGE: Historical tablespace usage metrics.TS$: Tablespace metadata.
- Uptime: Prevents outages caused by tablespaces reaching 100% capacity.
- Cost Control: Helps justify storage purchases and identify wasted space.
- Proactive Management: Allows DBAs to add space during maintenance windows rather than in a panic during business hours.
- 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