This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Click and register at Eventbrite
View analytic
Thursday, April 3 • 17:00 - 17:45
P97 How to create your own reports using the Dynamic Performance views, Statspack and Automatic Workload Repository (AWR)

Sign up or log in to save this to your schedule and see who's attending!

The Oracle Database is well instrumented to log performance data. This information is easy to access using the Dynamic Performance Views. Most tools aimed at analysing Oracle performance are based on these views.
Two well-known tools from Oracle are Statspack (free) and Automatic Workload Repository (requires a license).
The presentation describes some of the most interesting Dynamic Performance Views and their counterparts in the Statspack and AW repositories, and gives some examples on how you may use them to create your own reports. Examples: current top resource consumers, resource and wait trend analyses, analysing locking issues after the fact.
The presentation does not cover how to use the standard Statspack and AWR reports.

avatar for Odd Harry Ophaug

Odd Harry Ophaug

"Senior Technical Advisor at IFS Norge since 1991. Working daily with Oracle since 1987. Other databases since 1977.Main focus areas are performance analysis and technical issues."

Thursday April 3, 2014 17:00 - 17:45
Parliament Color Magic