Re: short of memory ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sun, 25 Apr 2004 00:05:09 GMT
Message-ID: <VgDic.30298$635.12763@nwrdny03.gnilink.net>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:408aecd6$0$442$afc38c87_at_news.optusnet.com.au...
> Anurag Varma wrote:
> [snip]
>
> >
> > Apart from what others have said, I do not see you setting worksize_area_policy=auto ..
> > for your pga_aggregate_target to come into effect.
> >
> > Anurag
>
> You don't need to, Anurag. A non-zero value for pga_aggregate_target
> automatically means worksize_area_policy is set to AUTO.
>
> Quite what use the second parameter is, therefore, remains a complete
> mystery to me (it makes no sense, after all, to request an aggregate
> target but then say you want to handle PGA allocations manually). But
> there it is.
>
> Regards
> HJR
You are correct. I was under the wrong impression.

Thanks for the correction.

Anurag Received on Sat Apr 24 2004 - 19:05:09 CDT