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_at_gmail.com] Sent: May 5, 2005 12:05 PM
To: BoivinP_at_mar.dfo-mpo.gc.ca
Cc: Oracle-L (oracle-l_at_freelists.org)
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_at_mar.dfo-mpo.gc.ca> 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