Welcome to OptimalDBA.com

Get Table Index Info - This reads the data dictionary and reports the current stats for a table and it's columns and indexes. I need to add support for partitioning. The only parameter is the fully qualified table name as <schema_name>.<table_name>. Access to DBA_ views is required.
Get Table Index Info History - This uses the same querying as the Get Table Index Info script, but includes the historical values of the stats. Handy for diagnosing performance changes when stats are gathered.

Stop Chasing Your Tail:Using a Disciplined Approach to Diagnosis presentation.

Never A DUL Moment presentation. Presented to the RMOUG November Quarterly Education Workshop

Advanced SQL presentation and script output. This was presented as a Masterclass for the 2008 UKOUG Conference and Exhibition

Real Life Recovery paper and presentation
Effective Troubleshooting for  Developers and Users seminar paper

Session event information and DEMO schema