Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Ram Raman <veeeraman@xxxxxxxxx>
  • Date: Wed, 11 Oct 2017 20:22:32 -0400

Well, Oracle advises you not to set it up explicitly. You CAN set it up explicitly if you need to do it for special workloads or if default is too restrictive. It is very hard to set it up below the default, you need pfile for that. If anything, you should increase it. Here is the note from Mike Dietrich:

https://mikedietrichde.com/2017/05/04/pga_aggregate_limit-enforces-default-since-oracle-database-12-2-0-1/

Also interesting are comments by Stefan Koehler below the post itself. My personal preference is to set it to 0, which means no limit, and have memory management done by the operating system.

Regards


On 10/11/2017 08:09 PM, Ram Raman wrote:

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 <mailto:gogala.mladen@xxxxxxxxx>> wrote:

    If you check the manual, always a good thing to do, Oracle
    recommends that you do not set that parameter.


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2017