Re: pga_aggregate_target question
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Thu, 6 Oct 2005 18:33:23 +0100
On 10/6/05, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
>
> If you set the parameter pga_aggregate_target and sort_area_size does
> oracle
> still use the sort area size parameter?
It depends on
a) the setting for WORKAREA_SIZE_POLICY current for the session.
b) the type of connection (shared servers or dedicated).
c) the version.
for 9i the manual settings are still used for shared server connections,
even with P_A_T and WORKAREA_SIZE_POLICY set. In 10g this changes and
SORT/HASH area size are not used unless the policy for the session is to use
them.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
