Re: NT read request size

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 10 Mar 1999 21:05:08 -0000
Message-ID: <921099952.2952.0.nnrp-03.9e984b29@news.demon.co.uk>

One option to check what it is for your hardware:

alter session set db_file_multiblock_read_count = 128; alter session set events '10046 trace name context forever , level 8'; select count(*) from very_large_table_without_indexes_and_not_parallel;

Then look at the trace file for WAIT 'db file scattered read' The size of the p3 parameter (number of blocks requested) is your answer.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Patricia Schorsch wrote in message <36E61FCA.97B86FA4_at_aol.com>...
>Does anyone know what the Windows NT 4.0 read request size is or how to
>calculate it if it is drive/cluster size dependent? I am trying to
>figure out what the maximum DB_FILE_MULTIBLOCK_READ_COUNT can be with a
>4KB DB_BLOCK_SIZE.
>
>Thanks,
>
>Patty Schorsch
>
Received on Wed Mar 10 1999 - 15:05:08 CST