Could it be that the execution plans are the same but work_area_policy is set to AUTO and the dedicated server sessions don't have sufficient memory and the shared server processes are using sort_area_size? Regards, Denny -- Denny Koovakattu Quoting krish.hariharan@xxxxxxxxxxxx:
I missed that mark completely - I interpreted the 1:30 to mean an hour 30 and missed the "1:30 min" in the original post. I have generally seen that behaviour only when you have a lot of requests coming in and it takes a -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier No, shared is faster, dedicated is factors of 10 slower. Other way round I wouldn't have messed around, nobody wants to execute this statements in shared server mode - we found out about shared mode "by accident" when we tried this from our web server and it was faster there.