Tag Archives: sqlperf.sql

Oracle performance mystery: wildly varying query response time

At this moment I’m working on a very weird performance issue on our Oracle Universal Content Management database. This is the query (actually with binds of course. Values for dReleaseState and dStatus are the same as far as I could … Continue reading

Posted in Oracle performance tuning | Tagged , , , , , , , , | 6 Comments

Planboard DBA Symposium: 17 juni 2014

Dutch-speaking readers of my blog might be interested to know I’ll be speaking at the 9th Planboard DBA Symposium at Oracle Nederland in De Meern. There will be (Dutch) sessions for DBAs and middleware specialists. I will do a session about first … Continue reading

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

A walkthrough through sqlperf 1.6 output (video)

I’ve made a video to walk you through the output of the sqlperf script version 1.6.

Video | Posted on by | Tagged , , , | Leave a comment

sqlperf.sql version 1.6 is out

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 , , , , , , , , | 6 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