Shrinking PGA of snp processes

From: "Boivin, Patrice J" <BoivinP@xxxxxxxxxxxxxxxxx>
To: "Oracle-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 05 May 2005 11:00:03 -0300

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

Follow-Ups:

Re: Shrinking PGA of snp processes
From: zhu chao

Other related posts:

Browse oracle-l