Category Archives: Oracle scripts

A couple of Enterprise Manager 12 repository scripts

For almost 2 years I’ve been product responsible/product owner for Oracle Enterprise Manager at Rabobank. I haven’t done a lot of technical stuff, but I did have access to the repository. This allowed me to create some queries, create some … Continue reading

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

Trace column 1.3

trace_column.sql is a script that you can use to quickly trace (event 10046) a couple of sessions with the same properties. For example: suppose there are multiple sessions of a user called APP_USER, you can start the trace on all … Continue reading

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

sqlperf_noawr.sql for the Diagnosics Pack impaired

So you want to do SQL performance investigations, but your Oracle database is Standard Edition or you have no Diagnostics Pack. These things happen. In fact, at my previous job only 2 out of 70 customers did have Diagnostics Pack. … Continue reading

Posted in Oracle performance tuning, Oracle scripts | 5 Comments

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

Advanced mining the log writer trace

I’ve been working on shell code to mine the log writer trace. I wrote about that two weeks ago. Now I have a more advanced piece of shell code that mines all log writer traces of all instances. It makes … Continue reading

Posted in Oracle performance tuning, Oracle scripts | 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

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