Re: pga_aggregate_target

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Thu, 13 May 2004 10:48:23 -0700 (PDT)
Message-ID: <20040513174823.98418.qmail@web50610.mail.yahoo.com>

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_at_cox.net 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 13 2004 - 13:06:00 CDT