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