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

Re: db_file_multiblock_read_count value

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 31 Oct 2002 22:06:34 +0000
Message-ID: <3DC1A96A.28B1@yahoo.com>


danilo wrote:
>
> 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

Oracle has a hard-coded max burnt into the kernel SSTIOMAX = 1M in all releases of Oracle from (I think) 8.0

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Thu Oct 31 2002 - 16:06:34 CST

Original text of this message

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