Tag Archives: parallel execution

Parallel query performance consistency

A collegue just asked me “didn’t you have a query to see what SQL has ran in parallel?” I’ve used this months ago and completely forgot, but this might come in handy again some day, so I’ll put this here. col … Continue reading

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

SQL*Net message from client on sqlplus?

Here is a very weird issue I encountered recently. I was working on a test to find out whether different values of parallel parameters would result in better performance for a data warehouse setup. I had noticed that several important SQL … Continue reading

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