Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
From: Martin Klier <usn_at_usn-it.de>
Date: Thu, 24 Apr 2008 13:17:30 +0200
Message-ID: <48106C4A.7050501@usn-it.de>
Date: Thu, 24 Apr 2008 13:17:30 +0200
Message-ID: <48106C4A.7050501@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-lReceived on Thu Apr 24 2008 - 06:17:30 CDT