Re: Shrinking PGA of snp processes

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


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

Other related posts: