multiblock_read_count on AIX4.3.3
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: multiblock_read_count on AIX4.3.3

  1. #1
    Join Date
    May 2000
    Location
    Mt. Laurel, NJ USA
    Posts
    4
    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?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    think so because each I/O in UNIX is 64K

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    DB_FILE_MULTIBLOCK_READ_COUNT

    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]

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ´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

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    apsn I remember which book now, it was one of Oracle ILT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width