Visual SQL Tuning – July 23 Webinar


Register now and join me on July 23 to discover how Visual SQL Tuning can help you understand execution plans and diagnose performance problems. During the webinar I'll cover:
  • Visual SQL Tuning basics and how to create a VST diagram
  • How to evaluate execution plan effectiveness with Visual SQL Tuning (more...)

Follow-up: Using Optimizer Hints for Oracle Performance Tuning Webinar

Thanks to everyone who attended my webinar on using hints for Oracle testing and performance tuning. As usual, it was a great event and I appreciate the comments and questions.

Downloads:
Presentation PDF
Related scripts
Webinar recording (coming soon)

I'll be back in the saddle again in July so keep (more...)

Using Optimizer Hints for Oracle Performance Tuning


My next Embarcadero sponsored webinar will be on May 14 and is entitled Using Optimizer Hints for Oracle Performance Tuning.

Register now!


Hints are excellent database performance tuning tools that direct the Oracle optimizer to utilize specific operations in SQL execution plans. We often use hints because the Oracle optimizer (more...)

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 (available soon)

Stay tuned for my next webinar coming in May!


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 (more...)