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_file_multiblock_read_count value

db_file_multiblock_read_count value

From: danilo <daniloa_at_bbirger.intnet.mu>
Date: 31 Oct 2002 04:26:58 -0800
Message-ID: <9713eeb.0210310426.17a11a7@posting.google.com>


Hi,
I would like to know why we can't set Oracle parameter db_file_multiblock_read_count greater than 128 on a Sun system running Solaris 8 (with latest patches) and Oracle 9i release 2.

On the OS side, we set the max. physical I/O size(maxphys) to 8 M in
/etc/system and sd_max_xfer_size is also set to 8M in the
/kernel/drv/sd.conf. We tried to set db_file_multiblock_read_count to
1024 as recommended by VERITAS (maxphys/Oracle_block_size) = 8 M/8 K but Oracle just seems to retain the 128 value.

Does anyone know if this is an Oracle limitation or something else?

Thanks

Danilo Received on Thu Oct 31 2002 - 06:26:58 CST

Original text of this message

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