Re: pga_aggregate_target

From: Richmond Shee <richmondshee_at_yahoo.com>
Date: Sun, 16 May 2004 19:53:23 -0700 (PDT)
Message-ID: <20040517025323.21922.qmail@web50501.mail.yahoo.com>

The white paper is available at IOUG website www.ioug.org or you can write me for a copy.    

Regards,  

Richmond.

Michael Thomas <mhthomas_at_yahoo.com> 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_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
-----------------------------------------------------------------
		
---------------------------------
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_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 Sun May 16 2004 - 21:50:24 CDT