I think pga_aggregate_target affects only memory allocation not = temporary space usage. It might affect the frequency and the sizing of temp allocations but I = think the total usage will be the same. This is based on the assumption that total sort/hash/whatever space = required to get the task done is higher than the allowed total memory = allocation. Waleed -----Original Message----- From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] Sent: Thursday, May 13, 2004 10:04 AM To: oracle-l@xxxxxxxxxxxxx Subject: pga_aggregate_target I have alot of batch loading processes that run over night. A few them = use 2GB or more of sort space in my temp tablespace. I know I can = increase my pga_aggregate_target dynamically, however, I believe I read = that oracle only allows 1 process to use up to 5% of the = pga_aggregate_Target. anyway to flex this up? I just need the extra sort space for a few = operations at certain times.=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------