Automatic Workload Repository Automatic Database Diagnostic Monitor Snapshots Physical Reads

We are top for USA Oracle Training Clients

Oracle support

Custom Oracle Training

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 - Automatic Workload Repository and Automatic Database Diagnostic Monitor

Creating Custom AWR Reports

A simple query to plot the user I/O wait time statistic for each AWR snapshot will be shown first. From physical_reads.sql the physical read counts from the AWR can be easily extracted.

physical_reads.sql

-- *************************************************
-- Copyright © 2004 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************

break on begin_interval_time skip 2

column phyrds format 999,999,999
column begin_interval_time format a25