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 -> DB_BLOCK_BUFFERS * DB_BLOCK_SIZE

DB_BLOCK_BUFFERS * DB_BLOCK_SIZE

From: SDC <sdcairns_at_mindspring.com>
Date: Mon, 24 May 1999 15:38:58 -0400
Message-ID: <7ic9in$397$1@nntp6.atl.mindspring.net> 





Sun Solaris E4000 (Solaris 2.6) w/ 1.5gb RAM
Oracle 8.0.5



DB_BLOCK_SIZE:    8192 (8K)



DB_BLOCK_BUFFERS:     100000



Question:



If this machine is dedicated to Oracle, why wouldn't I want to set the above
parameters which would allocate around 800mb for SGA?   The previous setting
was 5,500 block buffers which works out to 44MB and the system was pitifully
slow...



Received on Mon May 24 1999 - 14:38:58 CDT












Original text of this message













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