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

From: Martin Klier <>
Date: Thu, 24 Apr 2008 13:17:30 +0200
Message-ID: <>

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.

Usn's IT Blog for Linux, Oracle, Asterisk

Received on Thu Apr 24 2008 - 06:17:30 CDT

Original text of this message