Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db block size, too big wasting buffer?
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