Re: Shrinking PGA of snp processes

The reason why PGA memory never releases is because you are well under
your pga target.

There's is no need to schedule a "release" of this memory, unless your
target is innapropriate.

On 5/5/05, Boivin, Patrice J <BoivinP@xxxxxxxxxxxxxxxxx> wrote:
> Thanks.
>=20
> I can't do this randomly or at set intervals during the night though.
>=20
> Patrice.
>=20
> -----Original Message-----
> From: zhu chao [mailto:zhuchao@xxxxxxxxx]
> Sent: May 5, 2005 12:05 PM
> To: BoivinP@xxxxxxxxxxxxxxxxx
> Cc: Oracle-L (oracle-l@xxxxxxxxxxxxx)
> Subject: Re: Shrinking PGA of snp processes
>=20
> alter system set job_queue_processes=3D0;
> alter system set job_queue_processes=3DX;
>=20
> On 5/5/05, Boivin, Patrice J <BoivinP@xxxxxxxxxxxxxxxxx> wrote:
> > I noticed some of the snp processes take a LOT of memory, probably thei=
r
> PGA
> > grows to accommodate the largest nightly jobs.
> >
> > Looks like the PGA never shrinks back down, is there a way to force
> > processes to release PGA memory once they're done using it (in 8i -- we=
're
> > upgrading soon)?
> >
> > Other than setting a lower sort_area_size.
> >
> > Patrice.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>=20
> --
> Regards
> Zhu Chao
> www.cnoug.org
> --
> http://www.freelists.org/webpage/oracle-l
>=20


--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l

Other related posts: