Oracle SQL Performance Firefighting using AWR

Embarcadero

On Demand: Oracle SQL Performance Firefighting using AWR


Most of us have been in the situation where, for no apparent reason, performance for key SQL takes a nose-dive after having previously performed well. So, how do you handle this situation and stabilize performance back to acceptable levels? One approach is to go back in time using execution data stored in AWR. In many cases, AWR may contain what you need to revert your problem SQL to a better performing alternative.

Topics covered in the webinar include:

  • How to mine and analyze AWR data to review the SQL's performance over time
  • How to validate that the SQL is using the "good" execution plan
  • Tools to accelerate your analysis of AWR data and SQL code

karen_morton

About Karen Morton
Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior DBA Performance and Tuning Specialist.

For over 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle over a decade ago.

Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network.

She blogs at karenmorton.blogspot.com.