Tag Archives: sql_sql_id.sql

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

My oracle_performance github repository

After seeing Kyle Hailey’s ashmasters¬†GitHub repository (with all kinds of interesting scripts), I thought I might give it a try and start my own repository on GitHub. I blogged about some of my scripts before, but storing these on my … 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

sql_sql_id.sql 1.7

Here is thing with SQL tuning: at a certain point you encounter an inefficient SQL statement. You look at it with for example Active Session History. So you find out it does a full table scan on a big table. … Continue reading

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