Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count and performance

RE: db_file_multiblock_read_count and performance

From: <ryan_gaffuri_at_comcast.net>
Date: Mon, 06 Dec 2004 19:51:59 +0000
Message-Id: <120620041951.2010.41B4B85F00022451000007DA2200734748079D9A00000E09A1020E979D@comcast.net>


the maximum possible db_file_multiblock_read_count is 128. if you set it to this value and do a full tablescan then read the trace file you can get your 'actual' max readcount. look at db file scattered reads p3 values. look for the max value.

> I have been testing this extensively over the last few months. I do a
> full table scan with a db_file_multiblock_read_count =3D 1 and then one =
> =3D

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 06 2004 - 13:58:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US