Re: db_file_multiblock_read_count 10g default values
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Mon, 9 Nov 2009 08:56:15 -0800
On Fri, Nov 6, 2009 at 8:57 AM, Allen, Brandon
<Brandon.Allen@xxxxxxxxxxx>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: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
