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: DB_BLOCK_BUFFERS question

Re: DB_BLOCK_BUFFERS question

From: Kai Horstmann <horst_at_werum.de>
Date: Thu, 28 Jan 1999 00:11:45 +0100
Message-ID: <36AF9D31.EEC1098A@werum.de> 





Michael L. Mason schrieb:


> Max. number of DB_BLOCK_BUFFERS is 3200.  Is this


> correct?





No, Allocate as much as your memory controller allows.
But: do you really need as much memory for block buffers (1GB)?
Perhaps some indexes may reduce the need of full table scans.



Or do you need much space in the shared pool (SQL cache stored
procedures, PL/SQL tables and such stuff?



Good luck


Kai
Received on Wed Jan 27 1999 - 17:11:45 CST












Original text of this message













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