Tag Archives: Oracle SQL tuning

sqlperf.sql version 1.6 is out

Posted on February 1, 2014 by Marcel-Jan Krijgsman

The main inspiration for this new version of sqlperf.sql is the datawarehouse project I’m currently in. They have performance problems and parallellism seems to be one of the issues. So I needed to know over how many sessions parallellism had … Continue reading →

Posted in Oracle performance tuning | Tagged cursor_bind_capture_destination, dba_hist_sqlstats, execution plan, Oracle performance, Oracle SQL tuning, parallel execution, sql performance, sql plan baseline, sqlperf.sql | 6 Comments

Expensive full table scans on AQ$_SYS$SERVICE_METRICS_TAB_L

Posted on December 9, 2013 by Marcel-Jan Krijgsman

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 AQ$_SYS$SERVICE_METRICS_TAB_L, CJQ0 process, ORA-01405, Oracle database, Oracle performance, Oracle SQL tuning, sql_sql_id_html.sql, SYS$SERVICE_METRICS, troubleshooting | Leave a comment

sql_sql_id_html.sql version 1.4

Posted on November 19, 2013 by Marcel-Jan Krijgsman

[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 bind variables, Oracle performance, Oracle SQL tuning, sql_sql_id_html.sql, stats_sql_id_html.sql, timestamp data type | Leave a comment

sql_sql_id_html.sql version 1.2 is out

Posted on July 2, 2013 by Marcel-Jan Krijgsman

[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 GitHub, Oracle SQL tuning, performance, sql_sql_id_html.sql | Leave a comment

sql_sql_id_html.sql: a SQL performance script with HTML output

Posted on May 8, 2013 by Marcel-Jan Krijgsman

[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 GitHub, Oracle performance, Oracle SQL tuning, sql_sql_id.sql, sql_sql_id_html.sql | 1 Comment

sql_sql_id.sql 1.7

Posted on December 31, 2012 by Marcel-Jan Krijgsman

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 execution plan, Oracle SQL tuning, peformance, sql plan baseline, sql_sql_id.sql | 1 Comment