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.
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 ?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 05 2009 - 10:28:31 CDT