Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 11 Oct 2017 02:10:59 -0400

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


Other related posts: