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

Before asking for any good ideas, you need to share more valueable infos. - 10046 trace for the query on both configurations - 10053 trace for the query on both configurations

As you know it already, it's a matter of BAAG(Battle Against Any Guest).

Dion Cho

2008/4/24, Martin Klier <usn_at_usn-it.de>:
>
> 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