Re: PGA_AGGREGATE_TARGET question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 16 Aug 2003 01:00:25 GMT
Message-ID: <Jmf%a.36543$bo1.20127@news-server.bigpond.net.au>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F3CED70.46658F4A_at_remove_spam.peasland.com...
> > You mentioned above and elsewhere in your post that you will be wasting
> > memory if you set PAT too high. Interested to know how you come to that
> > conclusion as Oracle doesn't allocate the memory unless it's required.
>
> I wasn't aware of this and will update my records. So I now have a
> question. Why not just set P_A_T to some ungodly value, higher than
> you'll ever need it? I understand that you might want to make sure that
> if processes request it, you do not exceed physical RAM on the server.
> So that is probably the best reason to cap P_A_T.
>
> Thanks for the info,

Hi Brian

Exactly !!

Have a play and you'll be pleasantly surprised :)

Cheers

Richard Received on Fri Aug 15 2003 - 20:00:25 CDT