RE: I/O and db_file_multiblock_read_count

I apologize for the tardiness of my response. This is the result of timing the dd. It seems to indicate the same thing as the scattered read test. Or am I reading that wrong?

(8k * 16)
Unix> time dd if=/ora/data/bordcdw/users/users01.dbf of=/dev/null bs=131072
1290+1 records in
1290+1 records out

real        1.4
user        0.0
sys         0.5

(8k * 128)
Unix> time dd if=/ora/data/bordcdw/users/users01.dbf of=/dev/null bs=1048576
161+1 records in
161+1 records out

real        4.0
user        0.0
sys         0.0

On Fri, 2006-12-08 at 15:48 -0800, Kevin Closson wrote:
> do the "same" thing using dd. Whatever your db_block_size is, plug it
> in as follows:
>
> $ time dd if=<datafile_for_the tablespace> of=-/dev/null
> bs=<block_size_in_bytes*16>
>
> then re-run:
> $ time dd if=<datafile_for_the tablespace> of=-/dev/null
> bs=<block_size_in_bytes*128>
>
> please let me know what you find
>
>
>
>
> ______________________________________________________________
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Lidh
> Sent: Friday, December 08, 2006 12:46 PM
> To: oracle-l
> Subject: I/O and db_file_multiblock_read_count
>
>
>
> I was reading an article about the appropriate setting for
> db_file_multiblock_read_count. I'm on a HP-UX 11.11 64-bit
> system with Oracle 9.2.0.7.0. The original value was 16 and I
> bounced the database and ran a million record full-scan test
> (10046 trace) and then set the value to 128 (max value) and
> re-ran the

--
http://www.freelists.org/webpage/oracle-l