RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)


 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.



--
http://www.freelists.org/webpage/oracle-l

Other related posts: