Getting the Most Out of AWR by Tim Gorman
The Automatic Workload Repository is a significant part of Oracle's tuning advisories introduced in Oracle10g and further enhanced in Oracle11g. Enterprise Manager makes extensive use of AWR to enable performance tuning, but like STATSPACK before it, there is a lot more important information within AWR which can be obtained. The presenter will briefly explain the structure of the workload repository and how it is populated, but will mostly show attendees how to extract more information from this rich source of tuning information using SQL*Plus. This type of knowledge makes the difference between a DBA who is out of ideas once Enterprise Manager fails to yield a solution, and a DBA who knows how to tease out important evidence to resolve practically any problem that arises.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Tim Gorman
- Item #: Paper0048
