This page has links to useful Oracle performance tuning resources.
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
You’re Smarter Than a Database – Overcoming the optimizer’s bad cardinality estimates
SQL Tuning Scripts
Cardinality Errors Due to Relationships Between Columns
Introduction to SQL tuning
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!