ax read ahead block size

[William Clark_1]

I am trying to find out what the largest read ahead block size is for 11.00. I thought it was 64K but the DBA's say it is 128. Any help would be greatly appreciated as I love to work with the DBA's.

[A. Clay Stephenson]

My Installation Guide for ORACLE 8.0.X for HP 9000 Workstations and Servers (Oracle Part No. A75295-01) clearly states that if the values for the init.ora db_block_size and db_file_multiblock_read_count are multiplied, values greater than 64K automatically default to 64K. I have not checked 8.1.X yet MetaLink site appears to be down.

[William Clark_1]

Thanks. I will pass it on

[A. Clay Stephenson · Accepted solution]

Whoops, Metalink is now up and for HP-UX 11x the max is 256K. You can always set the value higher and ORACLE will then default to the OS maximum.

[William Clark_1]

do you know what the name of the paramter is in HPUX