DBA AWR System Metrics Summary – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports

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.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

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

Oracle EBS Tables Used

gv$system_parameter, v$parameter, dba_hist_snapshot

Report Categories

Enginatics

DBA SGA+PGA Memory Configuration, DBA AWR SQL Performance Summary, DBA Sessions, DBA AWR PGA History, DBA AWR Blocking Session Summary, DBA SGA SQL Execution Plan History, DBA SGA Buffer Cache Object Usage, DBA AWR SQL Execution Plan History, DBA AWR Tablespace Usage

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

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
SQL Source DBA AWR System Metrics Summary.sql
Full Report 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

© Enginatics GmbH