338: CSI Oracle � Investigate Past Performance Problems Using ASH, AWR, ADDM, and Optimizer Statistics
Patty Charlebois , Green Shield Canada    Biography

Objectives: Understand what is available to investigate past database performance issues
Learn what to look for in the ASH, AWR, ADDM and optimizer data
Know how to document your findings and prepare for future investigations.
Abstract: We�ve all been there. You leave to enjoy a nice relaxing week away from the office, only to come back to an inbox full of emails about database problems that occurred while you were away. Management is pressuring you to explain what happened and the fact that you were not at work is not an acceptable response. This presentation will show you how to use the Oracle automated toolset to go back in time and figure out what happened while you were away based on my own real-life experience.

Audiernce Focus: DBA
Expertise: Beginner
Track: Database
Date: Tuesday, April 15, 2008
Time: 1:45 PM - 2:45 PM