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

From: Denny Koovakattu <>
Date: Wed, 23 Apr 2008 17:41:47 -0500
Message-ID: <>

  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?


Denny Koovakattu


> 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: []
> 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.
Received on Wed Apr 23 2008 - 17:41:47 CDT

Original text of this message