Tag Archives: table statistics history

Statistics history, revisited

Tuesday last week I did a presentation on the Planboard DBA Symposium in De Meern, the Netherlands, about SQL performance issues. The scope of my presentation was what to do when a SQL statement suddenly does not perform adequately. Often … Continue reading

Posted in Oracle performance tuning | Tagged , , , , , , | Leave a comment

sql_sql_id_html.sql is now called sqlperf.sql (and new versions too)

[Update]: there is now a non-Diagnostics Pack version here. [Update]:┬áversion 1.6 is now out. More on this blogpost. My collegues are frequently using my SQL performance scripts, but there were some complaints that the scriptnames were a bit too long. … Continue reading

Posted in Oracle performance tuning, Oracle scripts | Tagged , , , | Leave a comment

A table statistics history case

Yesterday I got a question by mail to investigate a performance issue. A batchjob that started at 22:08, ran too long. I logged in on the database with Enterprise Manager and investigated the issue with the Oracle Diagnostics Pack. When … Continue reading

Posted in Oracle performance tuning | Tagged , , , , , , | Leave a comment