10g RAC and db_multi_block_read_count

From: Crisler, Jon <Jon.Crisler_at_usi.com>
Date: Wed, 5 Aug 2009 11:28:31 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB067504B4B59F_at_mds3aex08.USIEXCHANGE.COM>

If I allow Oracle 10g to automatically set the parameter db_multi_block_read_count, the value is determined to be 128 (8k blocksize). However, I ran across some comments that suggest in a RAC environment that this large size might be a bad choice, and it should be backed down to 8. I cannot find any info in statspack / AWR that suggests a smaller number is better in RAC.

Does anybody have further insight into this value in a RAC environment ?

Received on Wed Aug 05 2009 - 10:28:31 CDT

Original text of this message