From oracle-l-bounce@freelists.org Mon Dec 6 13:58:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB6Jw6U03149 for ; Mon, 6 Dec 2004 13:58:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iB6Jw6m03144 for ; Mon, 6 Dec 2004 13:58:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C966C72C693; Mon, 6 Dec 2004 15:04:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26018-05; Mon, 6 Dec 2004 15:04:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4C4472CCDF; Mon, 6 Dec 2004 14:59:07 -0500 (EST) From: ryan_gaffuri@comcast.net To: Waleed.Khedr@FMR.COM, Cc: "Khedr, Waleed" Subject: RE: db_file_multiblock_read_count and performance Date: Mon, 06 Dec 2004 19:51:59 +0000 Message-Id: <120620041951.2010.41B4B85F00022451000007DA2200734748079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 13184 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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