Re: Tuning the db_file_multiblock_read_count parameter

championsleeper wrote:

> We have a reasonably large database (~ 5 - 10 Tb ) and we're trying to
> tune the i/o. One of the parameters we are looking at is
> db_file_multiblock_read_count. in a system that is predominantly
> random i/o what affect does this value have?

Before you get there ... what is your PCTFREE and PCTUSED?

How much time are you wasting reading air?

The reason I asked is we made a huge improvement in a local phone company's month-end reports by just teaching them the concept of PCTFREE 0.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)