Printable View
I have seen in Metalink a statement to the effect that the value for db_file_multiblock_read_count cannot be greater than 64K/db_block_size, which for a db_block_size of 8K means it must be 8. The reference was for Oracle7.3.4, and I was wondering if it still holds true for Oracle8.1.6?
think so because each I/O in UNIX is 64K
Its max IO size/DB_BLOCK_SIZE. So, this definition is TRUE with later versions also.
Max value is always less than the calculated value as shown above, if its more than max value oracle uses max value.
Pando,
Each I/O need not be 64K. Depends on OS and Version. In Solaris its 128K. I think its preference depending on the application requirement. It can be created with a value you specify with some limitations.
There is an option in "newfs" command on solaris.
[Edited by sreddy on 02-08-2001 at 01:17 PM]
´well I am saying according to Tamilselvan, he has always said it´s64K and I also read from an unix book, cant remmeber if it was HPUX or Solaris
apsn I remember which book now, it was one of Oracle ILT