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 -> DB_MULTIBLOCK_READ_COUNT and DB_BLOCK_SIZE

DB_MULTIBLOCK_READ_COUNT and DB_BLOCK_SIZE

From: venkata terala <venkata_at_inetnow.net>
Date: 1997/07/19
Message-ID: <33D0ECFF.16B9@inetnow.net>#1/1

Hi! Oracle gurus

I am running 7.3.3.0.2 on Solaris 2.51. I need to know how much of a performance gain can one expect by increasing the DB_BLOCK_SIZE to 4 or 8K and the DB_MULTIBLOCK_READ_COUNT to 16 or 32 for a highly read intensive and low-write intensive setup. I understand that the results vary with every situation - but can I expect atleast a low to moderate performance gain ? Has anyone seen a case where doing so actually degraded performance ?
Or is my question too generic ?
Any input will be greatly appreciated

Venkat
vreddy_at_wsg1.usa.com Received on Sat Jul 19 1997 - 00:00:00 CDT

Original text of this message

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