Re: RTFM: Oracle 10g OS-specific default values

I've recenty been testing this (from IO perspective).

Funny thing is, it doesn't matter what value I use, as long as it is above 1.

WIth 2 and 128 i get the same Full tablescan performance. I am testing on Linux with RAW partitions, with 8gb full table scan, with single drive units.

I think 128 is the maximum value, right ?

I think that my perfromance observations are due to read ahead performed by the SAN hosting that single drive.

On Apr 7, 2005 11:45 AM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> a) are you talking about mbrc or db_file_multiblock_read_count?
>
> b) 4 seems an awfully small number to me. I personally like 128 or
> greater (but I'm not using RAC). What are the "issues" you refer to when
> mbrc>4 ? Are those specific to RAC?
>
> rjamya wrote:
>
> > I wouldn't go beyond 4 in a RAC, in 9ir2 you have few _issues_ to deal
> > with if mbrc > 4.
> >
> > Raj
> >
> > On Apr 7, 2005 10:43 AM, Levesque, Roger
> > <Roger.Levesque_at_valueoptions.com> wrote:
> >
> --
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l