File Library

How to Use an AWR/Statspack Report to Tune Oracle Systems

Topic: Webinars

Owner: Craig Shallahamer

Date: 2019-03-08

Subtopic:

Craig Shallahamer, Orapub

Life is good, until the phone rings and it's a performance issue. Most DBAs will immediately run an AWR or Statspack report. That's fine, but there is bad news. Most DBAs will also either stare at the report and freeze, start paging through the report looking for something, or post the report on a forum. None of these solutions are career-enhancing maneuvers.

The really good news is this presentation will teach you how to take an AWR report or a Statspack report and extract only the information you need, build a diagnostic framework to expose the biggest tuning opportunities, and then develop solutions that directly address them.

This step-by-step process can be used on any Oracle version, architecture, or configuration—cloud or on-premises. It's fast, it works, and it rocks! Join me as we explore how to quickly find solutions to the real performance problems.

Download File How to Use an AWRStatspack Report to Tune Oracle Systems C Shallahamer.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

Not a member? Click through to the topic of interest to browse a list of available presentations.
Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database