Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!newsfeed.mountaincable.net!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Date: Sun, 25 Apr 2004 08:40:27 +1000
From: "Howard J. Rogers" <hjr@dizwell.com>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: short of memory ?
References: <40881965$0$17595$636a15ce@news.free.fr> <j6vic.15414$eK3.8650@nwrdny01.gnilink.net>
In-Reply-To: <j6vic.15414$eK3.8650@nwrdny01.gnilink.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 19
Message-ID: <408aecd6$0$442$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 203.164.115.33
X-Trace: 1082846423  442 203.164.115.33
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260118

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