Re: Shrinking PGA of snp processes
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: BoivinP@xxxxxxxxxxxxxxxxx
- Date: Thu, 12 May 2005 15:41:51 -0400
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.
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>=20
> --
> Regards
> Zhu Chao
> www.cnoug.org
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
