Re: db_file_multiblock_read_count and performance

Don't forget 'as scalable as possible'.

Check the stats I posted earlier.

On Tue, 7 Dec 2004 13:19:19 -0600, Post, Ethan <Ethan.Post_at_ps.net> wrote:  

> I would think ideal is "as fast as possible" and assuming you tell
> Oracle the truth about speed of multiblock reads verse single block with
> optimizer_index_cost_adj everything should work out fine, even if full
> scans are favored. Of course too many scans at the same time and
> optimizer_index_cost_adj is no longer valid because IO bandwidth may
> effect response times, so I guess this is where system stats has a
> supreme advantage.
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l