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 -> Regarging Standard & Non-standard block size for db_cache

Regarging Standard & Non-standard block size for db_cache

From: qazmlp <qazmlp1209_at_rediffmail.com>
Date: 2 Nov 2004 02:26:19 -0800
Message-ID: <db9bbf31.0411020226.75d639e7@posting.google.com> 





Case-1)


  db_cache_size = 3600M



Case-2)


  db_cache_size = 600M


  db_8k_cache_size = 3000M



Will there be a difference in performance in the above cases?
On what basis, the DBA has to decide whether to use Standard 4K block
size or to have non-standard block sizes also for the Database?
Received on Tue Nov 02 2004 - 04:26:19 CST












Original text of this message













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