Re: Shrinking PGA of snp processes
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: BoivinP@xxxxxxxxxxxxxxxxx
- Date: Thu, 5 May 2005 23:04:39 +0800
alter system set job_queue_processes=3D0;
alter system set job_queue_processes=3DX;
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.
>=20
> 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'r=
e
> upgrading soon)?
>=20
> Other than setting a lower sort_area_size.
>=20
> Patrice.
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
