Tag Archives: sql plan baseline

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

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.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