Re: problems with pga_aggregate_target

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0312231117.1dd3d8f2_at_posting.google.com...
> our dba said he said the following:
>
> 'some complaining about system memory was used up when the target is
> set.'
>
>
> I need to research this. I cant find anything on google. anyone have
> comments? I thought pga_aggregate_target was the way to go.

Hi Ryan,

O/S Platform would surely be useful ...

On HP Tru64 with "Eager" swapping mode set we had a nasty shock with P_A_T in that the O/S was more than eager and "ate" all our 32G of swap space with less than 3G of PGA used. This was highlighted by Oracle Support as an expected feature !! By bouncing the box and setting the swap mode to lazy, P_A_T has subsequently worked beautifully with an overall saving of 2G of memory, better sort (etc.) performance and a rather idle swap disk as a result.

You could have run into the same/similar problem.

BTW, I discussed this here and at the L-Oracle Mail list a number of times.

Cheers

Richard Received on Tue Dec 23 2003 - 22:58:44 CST