Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: multiblock read count
: I have db_file_multiblock_read_count set to 16 and my block size
: is 4K. I remember reading somewhere that for optimal performance
: db_file_multiblock_read_count * db_block_size should be 64 KB.
I think 64kb could be increased for modern discs and controllers. Maybe there are limitations from OS for maximum IO size.
Starous Received on Thu Sep 14 2000 - 07:40:29 CDT