Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 11 Oct 2017 02:10:59 -0400
Message-ID: <8c62bdca-a962-231f-be24-e8d7d9b5c6ef_at_gmail.com>
Date: Wed, 11 Oct 2017 02:10:59 -0400
Message-ID: <8c62bdca-a962-231f-be24-e8d7d9b5c6ef_at_gmail.com>
If you check the manual, always a good thing to do, Oracle recommends
that you do not set that parameter.
On 10/10/2017 06:02 PM, Ram Raman wrote:
> "alter system set pga_aggregate_limit=8000G SCOPE=BOTH;"
>
> I wouldnt do that even if you have TBs of memory in your server!
>
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 11 2017 - 08:10:59 CEST