Thanks. I can't do this randomly or at set intervals during the night though. Patrice. -----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 alter system set job_queue_processes=0; alter system set job_queue_processes=X; On 5/5/05, Boivin, Patrice J <BoivinP@xxxxxxxxxxxxxxxxx> wrote: > I noticed some of the snp processes take a LOT of memory, probably their 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 > -- Regards Zhu Chao www.cnoug.org -- //www.freelists.org/webpage/oracle-l