Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
Date: Thu, 24 Apr 2008 14:48:11 -0400
Did you try to turn on tracing for the 2 different sessions to see what the hold up is?
On 4/24/08, Martin Klier <usn_at_usn-it.de> wrote:
> Hi Denny,
> Denny Koovakattu schrieb:
> > 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?
> How can I check that?
> I did set work_area_policy to manual - no change.
> I did set alter session sort_area_size=262144 for ded and shared tests
> as well - no change.
> Any idea is greatly appreciated.
> Usn's IT Blog for Linux, Oracle, Asterisk