| layout | default |
|---|---|
| title | DBA AWR System Metrics Summary | Oracle EBS SQL Report |
| description | Historic system statistics from the automated workload repository showing CPU load, wait time percentage, logical (buffer/RAM) and physical read and write… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Diagnostic Pack, Enginatics, DBA, AWR, System, Metrics, gv$system_parameter, v$parameter, &sysmetric_view |
| permalink | /DBA%20AWR%20System%20Metrics%20Summary/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Historic system statistics from the automated workload repository showing CPU load, wait time percentage, logical (buffer/RAM) and physical read and write IO figures, summarized in snapshot time intervals. All IO figures are measured in MB/s.
-CPU%: Total CPU usage percentage. If this is low, the hardware is underused and performance could potentially get improved by using it better e.g. by resolving IO bottlenecks (bigger RAM, faster storage) or parallelization of SQLs and user processes. -WAIT%: Percentage of time that the DB process spends waiting rather than processing. If the wait% is high and most of the wait time is spend e.g. waiting for IO, then the storage is too slow compared to CPU speed. -BUFF_READ: Logical IO read from the buffer cache (RAM) in MB/s -PHYS_READ: Physical IO read from the storage in MB/s -PHYS_WRITE: Physical IO written to the storage in MB/s
Note: The UOM calculation from LIOs to MB uses the database default block size and doesn't support different block sizes for different tablespaces.
Date From, Date To, Show Daily Averages, Diagnostic Pack enabled, Container Data
gv$system_parameter, v$parameter, &sysmetric_view, dba_hist_snapshot, &sysmetric_symmary_view
DBA SGA+PGA Memory Configuration, DBA AWR Settings, DBA AWR SQL Performance Summary, CAC Inventory Pending Cost Adjustment - No Currencies, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, Blitz Report History, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory to G/L Reconciliation (Restricted by Org Access), CAC Inventory and Intransit Value (Period-End)
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 System Metrics Summary 13-Jul-2018 173115.xlsx |
| Blitz Report™ XML Import | DBA_AWR_System_Metrics_Summary.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-awr-system-metrics-summary/ |
The DBA AWR System Metrics Summary report provides a high-level dashboard of the database's vital signs over time. It summarizes key system-wide metrics like CPU Load, Wait Percentage, and I/O Throughput (MB/s). This report is ideal for spotting trends, identifying peak load windows, and correlating system behavior with user complaints.
- Health Check: "Is the database healthy right now? How does it compare to last week?"
- Bottleneck Identification: "Are we CPU bound (high CPU%) or I/O bound (high Wait% and Phys Read)?"
- Throughput Analysis: "What is our peak I/O throughput? Do we need a faster SAN?"
This report aggregates system metrics from AWR snapshots.
Key Features:
- CPU %: Total CPU utilization.
- Wait %: Percentage of time sessions spent waiting.
- I/O Metrics: Buffer Read (Logical), Physical Read, and Physical Write in MB/s.
- Snapshot Granularity: Shows how these metrics evolve hour by hour.
The report queries DBA_HIST_SYSMETRIC_SUMMARY (or similar views depending on version).
Key Tables:
DBA_HIST_SYSMETRIC_SUMMARY: Summarized system metrics.DBA_HIST_SNAPSHOT: Snapshot timing.
- Executive Reporting: Provides simple, understandable charts for management (e.g., "CPU usage is up 20% year-over-year").
- Proactive Sizing: Helps predict when the system will hit hardware limits.
- Incident Correlation: Helps correlate "slow system" tickets with actual server load metrics.
- 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