20 Years of Oracle Performance Tuning

Top Tips for Winning the Race

Of all the database chores, I've always found performance tuning to be the most interesting.  It's part art and part science.  In this post, I list the tips that I believe are among the most important lessons.

TIP #1:  Don't Begin with Parallelism

TIP #2: Root Cause First, Solution Second

TIP #3: Be an Expert on Active Session History

TIP #4: Become Adept at using Sql Hints

TIP #5: Understand Stored Outlines

TIP #6: Diagram Complicated Joins

 

 

TIP #7: Be Slow to Blame Insufficient Resources

 

 

 

 

TIP #8: Understand Flashback Queries

TIP #9: Consider Query Subfactoring

I hope you find these tips useful. Performance tuning is one of the most challenging--and rewarding--parts of database management.

Photos courtesy of James Thomas