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 size, too big wasting buffer?

Re: db block size, too big wasting buffer?

From: John Beresniewicz <jberesniewicz_at_comcast.net>
Date: Mon, 24 Jun 2002 22:29:55 GMT
Message-ID: <D3NR8.375033$%y.28504063@bin4.nnrp.aus1.giganews.com>


Keep in mind that on 9i you can could use a 16K default block size as well as a dedicated 4K cache (block) size just for the OLTP table. This should minimize block contention as well as isolate (and tune) buffer cache and provide dedicated LRU working sets for this presumably all-important object.

Sure sounds like having your cake and eating it too in this case. Received on Mon Jun 24 2002 - 17:29:55 CDT

Original text of this message

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