Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i r4 on win2000 pro with 8GB

Re: oracle 9i r4 on win2000 pro with 8GB

From: Matthias Wirtz <Matthias.Wirtz_at_abbrevation.com>
Date: Mon, 02 Aug 2004 14:51:49 -0400
Message-ID: <2n7h0cFt909hU1@uni-berlin.de> 





Howard J. Rogers wrote:


>> I have a big box (Intel - win200) with 8GB of memory. I thought having a
>> total SGA (oracle 9i r4) of 4 - 5 GB




> 

> Why?

> 

> I'll lay odds you don't need such a large SGA. Most people don't.




Most of it would be used as db_cache in order to minimize hard drive access 
and to have space for even big sort operations usually performed in the 
temporary tablespace.

--
Matthias Wirtz - Norfolk, usa


Received on Mon Aug 02 2004 - 13:51:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US