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

Did you try to turn on tracing for the 2 different sessions to see what the hold up is?

Finn

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.
> Thanks
> usn
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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