DBA AWR System Metrics Summary – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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.

Report Parameters

Date From, Date To, Show Daily Averages, Diagnostic Pack enabled, Container Data

Oracle EBS Tables Used

gv$system_parameter, v$parameter, &sysmetric_view, dba_hist_snapshot, &sysmetric_symmary_view

Report Categories

Diagnostic Pack, Enginatics

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)

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 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/

Executive 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.

Business Challenge

Solution

This report aggregates system metrics from AWR snapshots.

Key Features:

Architecture

The report queries DBA_HIST_SYSMETRIC_SUMMARY (or similar views depending on version).

Key Tables:

Impact

© 2026 Enginatics