Oracle Scratchpad

AWR / Statspack

People frequently ask questions about interpreting statspack (and AWR) outputs. So I’ve started to collect references to examples of statspack (and AWR) outputs that have been published on the Internet with intelligent comments about interpretation. A few of the items are about related topics, rather than output and interpretation.

There are bound to be more items out there than I currently know of, so if you know of any good examples, add it to the comments list and if I like it I’ll add it to the main list.

Getting Started: if you don’t know how to install or use statspack, then the best place to start is on your server by reading the documentation at $ORACLE_HOME/rdbms/admin/spdoc.txt, which describes how to install it, how to take snapshots, and how to use the reporting facilities.

Footnote: Any advice about reading statspack reports is almost always relevant when reading AWR reports.

3 Comments »

  1. Great collection. Thanks.

    Comment by Fahd Mirza — February 6, 2011 @ 11:15 am UTC Feb 6,2011 | Reply

  2. The papers at the top of the list from Connie Dialeris Green and Graham Wood seem to drift around as Oracle Corp. re-organizes the TechNet website. At present they are in the “database/focus-areas” directory.

    If the current links fail for you, please add a comment so that I can find and relink them.

    Comment by Jonathan Lewis — March 9, 2011 @ 9:37 am UTC Mar 9,2011 | Reply

  3. This may also be of interest from Tim Gorman.
    http://www.evdbt.com/papers.htm
    RDBMS Forensics using ASH

    The audio may aslo be available on demand in the near future
    as he gave a version of this at the following online confrence.

    http://www.brainsurface.com/virtathon/sessions-schedule

    Ron

    Comment by Ron Chennells — August 4, 2011 @ 1:06 pm UTC Aug 4,2011 | Reply


RSS feed for comments on this post.

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 )

Connecting to %s

Theme: Rubric. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 1,398 other followers