Welcome to OptimalDBA.com



Update April 8, 2009
Scripts
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.

Update February 12, 2009
Papers
Stop Chasing Your Tail:Using a Disciplined Approach to Diagnosis presentation.

Update December 16, 2008
Papers
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

Update September 17, 2008


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


Update March 12, 2008

Scripts
Session event information and DEMO schema

Update January 22, 2007

I've added some content to Papers and Presentations and Scripts. Slowly, but surely, I'm adding content...