Re: Where best to cache the disk

Paul Beardsell (psb_at_sambusys.demon.co.uk) wrote:

: I am tempted to assign all our spare memory to the Unix disk
: cache (by increasing NBUF etc) and to keep the SGA just big
: enough for DC_* dictionary caching.
 

: What say you?

From my experience, it is better to allocate the memory to the SGA, dictionary cache first (or shared pool on V7). I have experimented at some length with various file system/raw partition setups. I found the best performance with an extent based file system and multi disk striping. Also the block size of the file system vs the Oracle block size is important.

Nick

--
+==============================================================================+
+    Nick Price                                                                +
+    Internet: nprice_at_innet.be                                                 +
+    Tel/Fax : +32 2 347 1101                                                  +
+==============================================================================+