Tuning The Untunable: When Indexes and Optimizer Don’t Help


In 2004, I gave a tuning presentation in the Boston area at NOUG
http://noug.com/

If you haven’t seen it, do take a look. It actually went viral and I received emails from around the world.

The PDF can be found here:
https://rodgersnotes.wordpress.com/2010/09/14/oracle-performance-tuning/

Recently, I gave a tuning presentation at the Manitoba Oracle User’s Group
http://mboug.wordpress.com/

This MBOUG presentation is a follow up. It covered a number of very mysterious tuning scenarios that I’ve encountered since NOUG, and the techniques I used to overcome them. In these cases, using optimizer and indexes usually did not help at all.

The PDF can be found here:  

Tuning the Untunable

Do check it out.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: