Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: Martin Klier <usn@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxxx
- Date: Thu, 24 Apr 2008 13:17:30 +0200
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:
