Re: Multi-Block read count

"Herman de Boer" <h.de.boer_at_itcg.nl> wrote in message news:bde5777e.0201090629.78036153_at_posting.google.com...
> hello Norman,
>
> it is platform dependent. The method I use in order to determine the
> maximum in a database is simple, using sqlplus:
> * alter session set db_file_multiblock_read_count = 10000;
> * show parameters db_file_multiblock_read_count
>
> On my NT laptop, with RDBMS 9.0.1, db_file_multiblock_read_count can
> be set to 64, so with 8 Kb block size, at most 512 Kbyte can be read.

snip

from a compaq server we have

SQL> alter session set db_file_multiblock_read_count = 10000;

Session altered.

SQL> show parameter multiblock;

NAME                                 TYPE    VALUE
------------------------------------ ------- --------------------
db_file_multiblock_read_count        integer 128
hash_multiblock_io_count             integer 0
sort_multiblock_read_count           integer 2

suggesting that it might be hardware specific as well - this is an nt4 server. Nice trick though.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************