Re: Re: Automatic tuning of db_file_multiblock_read

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 15 Jul 2005 14:49:37 +0800
Message-ID: <5e30486205071423497956b84a@mail.gmail.com>

Its something you can do just as easily on v9 - we've done it here and had some good results to date

set db_file_mu... to 128 in your spfile (where 128 equates to the max IO for your OS)
set mbrc to "n" in system stats (we went for 16, but its just a case of finding what's best for you)
ensure MREADTIM is greater then SREADTIM so that mbrc is picked up

hth
Connor

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 15 2005 - 01:51:35 CDT

Re: Re: Automatic tuning of db_file_multiblock_read_count ???