Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY

  • From: Ram Raman <veeeraman@xxxxxxxxx>
  • To: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • Date: Wed, 11 Oct 2017 19:09:03 -0500

Sorry, I am confused. Then why would they provide that parameter at all. In
that link you provided it talks about setting the parameter.

On Wed, Oct 11, 2017 at 1:10 AM, Mladen Gogala <gogala.mladen@xxxxxxxxx>
wrote:

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: