Loading…
Click and register at Eventbrite
Back To Schedule
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, view media, leave feedback and see who's attending!

Tweet Share
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.
Foredragsholdere
avatar for Odd Harry Ophaug

Odd Harry Ophaug

IFS
"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 CEST
Parliament Color Magic
  Core Tech