OracleBlog

Recently Dr. Tim Hall posted a brief blog on SQL Tuning. He may have based it on a number of questions on the topic that have popped up recently on some of the Oracle forums.

http://oracle-base.blogspot.com/2005/10/no-shortcuts-for-sql-tuning.html

You might also have seen Steve Callan's 2-part article on Oracle Performance Tuning on DBASupport.com:

http://www.dbasupport.com/oracle/ora10g/perfTuning01.shtml

So I was searching for a good article I had once read on this topic, and I found it. Here it is, courtesy of Ian Jones and Roger Schrag of Database Specialists:

http://www.dbspecialists.com/presentations.html#perf_bottleneck

The articles on their site are sometimes dated, but I still find them useful and interesting. Here is a particularly fun article on "Database Mysteries" courtesy of Chris Lawson:

http://www.dbspecialists.com/presentations.html#dba_mysteries