Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Shrinking PGA of snp processes
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-lReceived on Thu May 05 2005 - 10:06:19 CDT