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 at 16?

Re: db_file_multiblock_read_count at 16?

From: Kai Horstmann <horst_at_werum.de>
Date: Tue, 21 Jul 1998 21:45:58 +0200
Message-ID: <35B4EFF6.1C758BE1@werum.de>


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 Received on Tue Jul 21 1998 - 14:45:58 CDT

Original text of this message

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