Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY
From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 11 Oct 2017 19:09:03 -0500
Message-ID: <CAHSa0M0tRFmYCHi0ernKaYdbkmdxcGRJm1b=ZCXsjNSiAYtrOg_at_mail.gmail.com>
Date: Wed, 11 Oct 2017 19:09:03 -0500
Message-ID: <CAHSa0M0tRFmYCHi0ernKaYdbkmdxcGRJm1b=ZCXsjNSiAYtrOg_at_mail.gmail.com>
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>
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
>
>
>
-- -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 12 2017 - 02:09:03 CEST