Re: db_file_multiblock_read_count 10g default values

From: Jared Still <>
Date: Mon, 9 Nov 2009 08:56:15 -0800
Message-ID: <>

 On Fri, Nov 6, 2009 at 8:57 AM, Allen, Brandon <>wrote:

> I also agree this method of "auto-tuning" isn't sucha a good idea since if
> you set your db_cache_size/sga_target too low or your sessions too high,
> then you may be inadvertently throttling down your multiblock reads more
> than you should. I'm thinking in my specific situation I'll gather
> system_stats to set mbrc for optimization and then set
> db_file_multiblock_read_count=128 manually instead.

It appears that the following conclusion may be drawn:

Automatic tuning isn't really automatic.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

Received on Mon Nov 09 2009 - 10:56:15 CST

Original text of this message