Re: db_file_multiblock_read_count at 16?

Yes Kai it points in this direction.

db_file_multiblock_read_count * db_block_size + some_overhead <= OS-Read_Blocksize.

Overhead fot NT is 512 Byte.

Kai Horstmann schrieb:
>
> Cheng-Jih Chen schrieb:
> >
> > I'm trying to set db_file_multiblock_read_count at something higher
> > than 16 on both Oracle 7.3.3 and Oracle 7.3.4 servers running Solaris
> > 2.5.1, but my change in the init.ora file doesn't seem to be taking.
> >
> > I'm aware of the (db_block_buffers/4) >= db_file_multiblock_read_count
> > constraint, but db_block_buffers is set at a much higher number than
> > 64.
> >
> > Thanks for any pointers.
>
> I heared something about a restriction of the HP-UX-implemantation, that
> only 64K can be read wit one I/O-Statement. Perhaps this restriction
> meets your system too?
>
> Kai

--

Regards

Matthias Gresz :-)

--
GreMa_at_t-online.de

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\