Re: db_file_multiblock_read_count 10g default values

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 9 Nov 2009 08:56:15 -0800
Message-ID: <bf46380911090856v5d2a83cbpd459b3ca1ae99aa0_at_mail.gmail.com>

 On Fri, Nov 6, 2009 at 8:57 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com>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

--
http://www.freelists.org/webpage/oracle-l

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