Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems with pga_aggregate_target
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<829Gb.63613$aT.16120_at_news-server.bigpond.net.au>...
> "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
we are on solaris. any word on that platform? Received on Wed Dec 24 2003 - 07:33:01 CST