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:
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:
Do check it out.