Jonathan Lewis

Interpreting Statspack (and AWR)

How do you interpret a Statspack (or AWR) report ?

There aren't many things that can go wrong with an Oracle database, and many of the larger issues can be identified quite rapidly through snapshots of the dynamic performance views.

In this presentation, we will discuss a couple of strategies for using the Statspack/AWR reports; then look at how you identify the top one or two issues that are likely to be the best places to invest your tuning efforts. But one of the best ways to learn how to investigate problems is to watch it happening. So after the introduction, I will invite the audience to supply text versions of production AWR or statspack reports and use them to demonstrate how to extract useful information from them.