This page has links to useful Oracle performance tuning resources.

Github repository:


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:

Delphix User Experience

PowerPoint WebEx recording

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


Exadata Distinctives


Introduction to SQL tuning

PDF, Zip, Powerpoint

– Bobby






One Response to Resources

  1. Jags S says:

    This is nice website..I am also posted good articles on the site
    if you get time,please do check and comments

Leave a Reply