Tuesday, March 26, 2013
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:
Stay tuned for my next webinar coming in May!
Tuesday, March 12, 2013
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".
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