Re: db_file_multiblock_read_count and performance
- From: Jared Still <jkstill@xxxxxxxxx>
- To: "Post, Ethan" <Ethan.Post@xxxxxx>
- Date: Tue, 7 Dec 2004 12:07:26 -0800
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@xxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
