Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: pga_aggregate_target question
On 10/6/05, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
It depends on
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 06 2005 - 12:36:35 CDT
![]() |
![]() |