Martin Klier


Creating Oracle AWR reports quicksheet

For comparing, classifying, benchmarking and forecasting databases, Oracle’s Automatic Workload Repository (AWR) is neat. (But remember! You will need a diagnostics pack license for that as described here and here – if you need a free technology for performance monitoring, consider using Craig Shallahamer’s OSM toolkit.)

This post simply describes the package calls to create a AWR report, for details please see the Oracle documentation or oracle-base.com.

If you need to create a snapshot manually, because you don’t like the one-hour interval, or if you disabled taking snapshots at all:


Create a report:


This script will ask you for the format of the report (html or plain text), the snapshot ID for start and end of the report (an overview of the last n day’s snapshots is given) and for a report name, that’s used for the report file name (.html or .lst).

Stay happy with your databases,

Setting ulimit -m in AIX
Oracle 11g JDBC driver hangs blocked by /dev/random – entropy pool empty

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.