Tuesday, March 26, 2013

Back to the Future AWR Mining Webinar Followup



Thanks to everyone who attended my webinar and thanks to Embarcadero (@DBPowerStudio) for hosting it. The presentation and scripts can be downloaded from the following links:

Presentation (PDF)
Scripts (ZIP)
Webinar recording


Stay tuned for my next webinar coming in May!


Tuesday, March 12, 2013

Webinar - Back to the Future: Oracle SQL Performance Firefighting using AWR


It's webinar time again! On March 26, Embarcadero will once again provide sponsorship for my webinar entitled "Back to the Future: Mining AWR Data for Oracle SQL Performance".

Abstract
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.

Register for the webinar now to learn:
  • 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
There are two sessions (one at 10am EDT and one at 2pm EDT). I hope to see you there!