Resources

This page has links to useful Oracle performance tuning resources.

Scripts:

Package to extract select statements from source database and run them in different scenarios comparing their plans, run time, and resource consumption: zip

Script to show the executions of a given SQL statement over time: zip

Collection of sql tuning scripts I use most often: zip

My papers and presentations:

Focusing Your Oracle Database Tuning Efforts For PeopleSoft Applications

Powerpoint, Word, Zip

You’re Smarter Than a Database – Overcoming the optimizer’s bad cardinality estimates

Powerpoint, Word, Zip

SQL Tuning Scripts

Powerpoint, Zip

Cardinality Errors Due to Relationships Between Columns

Word

Exadata Distinctives

Powerpoint

Introduction to SQL tuning

PDF, Zip, Powerpoint

Note that some of my older presentations refer to my old GeoCities blog.  The GeoCities blog is archived at this site: http://wayback.archive.org/web/20091027013758/http://geocities.com/bobbyandmarielle/

So, if you see any references to http://geocities.com/bobbyandmarielle/ just add http://wayback.archive.org/web/20091027013758/ to the front of the URL and you will find it.  Very cool archive!

– Bobby

 

 

 

 

 

Leave a Reply