Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY
Date: Wed, 11 Oct 2017 20:22:32 -0400
Message-ID: <cf232808-b63e-d365-de0f-6e1a252b23a7_at_gmail.com>
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:
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_at_gmail.com <mailto:gogala.mladen_at_gmail.com>> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 12 2017 - 02:22:32 CEST