RE: Shrinking PGA of snp processes

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.
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: