Home > Miscellaneous > AWR Reports

AWR Reports

AWR reports are available at the location $ORACLEHOME/rdbms/admin . Below is the list of important ones’

awrrpt.sql    -- basic AWR report
awrsqrpt.sql  -- Standard SQL statement Report
awrddrpt.sql  -- Period diff on current instance
awrrpti.sql   -- Workload Repository Report Instance (RAC)
awrgrpt.sql   -- AWR Global Report (RAC)
awrgdrpt.sql  -- AWR Global Diff Report (RAC)
awrinfo.sql   -- Script to output general AWR information
awrblmig.sql  -- AWR Baseline Migrate
awrload.sql   -- AWR LOAD: load awr from dump file
awrextr.sql   -- AWR Extract
awrddinp.sql  -- Get inputs for diff report
awrddrpi.sql  -- Workload Repository Compare Periods Report
awrgdinp.sql  -- Get inputs for global diff reports
awrgdrpi.sql  -- Workload Repository Global Compare Periods Report
awrginp.sql   -- AWR Global Input
awrgrpti.sql  -- Workload Repository RAC (Global) Report
awrinpnm.sql  -- AWR INput NaMe
awrinput.sql  -- Get inputs for AWR report
awrsqrpi.sql  -- Workload Repository SQL Report Instance
Categories: Miscellaneous Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.


Where all the Action Is !!!!

Pavan DBA's Blog

The DBA Knowledge Store

ORACLE-BASE - Latest Articles

Where all the Action Is !!!!

%d bloggers like this: