RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
From: Denny Koovakattu <oracle-l_at_koovakattu.com>
Date: Wed, 23 Apr 2008 17:41:47 -0500
Message-ID: <20080423174147.qhdofhjv21c0w0cc@webmail.koovakattu.com>
Date: Wed, 23 Apr 2008 17:41:47 -0500
Message-ID: <20080423174147.qhdofhjv21c0w0cc@webmail.koovakattu.com>
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_at_quasardb.com:Received on Wed Apr 23 2008 - 17:41:47 CDT
> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> 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