Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: usn@xxxxxxxxx
- 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?
Finn
On 4/24/08, Martin Klier <usn@xxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts: