Re: Shrinking PGA of snp processes

From: zhu chao <zhuchao_at_gmail.com>
Date: Thu, 5 May 2005 23:04:39 +0800
Message-ID: <962cf44b050505080436a9649d@mail.gmail.com>

alter system set job_queue_processes=3D0; alter system set job_queue_processes=3DX;

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.

>=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

Received on Thu May 05 2005 - 11:09:05 CDT