The white paper is available at IOUG website www.ioug.org or you can write me for a copy. Regards, Richmond. Michael Thomas <mhthomas@xxxxxxxxx> wrote: I'm not sure if sort space is necessarily the problem. R. Shee gave an interesting presentation on sort memory usage related to performance at Charlotte in February. The presentation is at: http://www.cltoug.org/presentations/RichmondSheeCLTOUGFeb2004.zip There are some tips in the presentation that may help you assess memory vs. performance for your loads. Good luck. Regards, Mike Thomas --- ryan.gaffuri@xxxxxxx wrote: > 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. > __________________________________ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. ---------------------------------------------------------------- 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 -----------------------------------------------------------------