Tag Archives: sql_sql_id_html.sql

Expensive full table scans on AQ$_SYS$SERVICE_METRICS_TAB_L

A while ago a collegue DBA asked me to help him with a database he had problems with. The database was generating a lot of archives and since there also was a standby database, these archives had to be transported … Continue reading

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

sql_sql_id_html.sql version 1.4

[Update]: there is now a non-Diagnostics Pack version here. [Update]: version 1.6 is now out. More on this blogpost. A collegue pointed out that sql_sql_id_html.sql doesn’t show binds with the timestamp data type. It turns out that for bind variables with … Continue reading

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

Version 1.3 of sql_sql_id_html.sql and a new script: stats_sql_id_html.sql

[Update]: there is now a non-Diagnostics Pack version here. [Update]: version 1.6 is now out. More on this blogpost.   Two weeks ago I was asked to help solve urgent performance problems on a large database. What SQL statement caused the … Continue reading

Posted in Oracle performance tuning | Tagged , , | 1 Comment

sql_sql_id_html.sql version 1.2 is out

[Update]: there is now a non-Diagnostics Pack version here. [Update]: version 1.6 is now out. More on this blogpost. Version 1.2 of my SQL performance reporting script sql_sql_id_html.sql is out. In this version I’ve added query statistics from AWR. And I … Continue reading

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

Performance tuning, a medical drama – Act one

The telephone of the first responders of our DBA team rings. One of them takes up the phone and quickly scribles some notes. Apparently a severity 2 incident has been issued. Application XYZ is not well and the collegue on … Continue reading

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

sql_sql_id_html.sql: a SQL performance script with HTML output

[Update]: there is now a non-Diagnostics Pack version here. [Update]: version 1.6 is now out. More on this blogpost. A while ago I read a blogpost by Tanel Poder about HTMLizing your sqlplus output. I used to make sqlplus scripts with … Continue reading

Posted in Oracle performance tuning, Oracle scripts | Tagged , , , , | 1 Comment