From oracle-l-bounce@freelists.org Tue Nov 23 13:55:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iANJtQ932259 for ; Tue, 23 Nov 2004 13:55:26 -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 iANJtQx32254 for ; Tue, 23 Nov 2004 13:55:26 -0600 Received: from localhost (freelists-183.iquest.net [206.53.239.183]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 239FB72E591; Tue, 23 Nov 2004 15:01:46 -0500 (EST) Received: from turing.freelists.org ([206.53.239.180]) by localhost (misc.avenirtech.net [206.53.239.183]) (amavisd-new, port 10024) with ESMTP id 10547-82; Tue, 23 Nov 2004 15:01:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 81A3872E6B5; Tue, 23 Nov 2004 13:29:09 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: How reliable are IO timing statistics in v$filestat/x$kcfio in Oracle 9.2 Date: Tue, 23 Nov 2004 12:03:05 -0500 Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0C53643@usa0300ms03.na.xerox.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How reliable are IO timing statistics in v$filestat/x$kcfio in Oracle 9.2 Thread-Index: AcTRfkw2OmHrn9FJR1ePiJyhQT64BQ== From: "Hameed, Amir" To: X-OriginalArrivalTime: 23 Nov 2004 17:03:05.0577 (UTC) FILETIME=[4CADF590:01C4D17E] Content-Transfer-Encoding: 8bit X-archive-position: 12641 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Amir.Hameed@xerox.com Precedence: normal Reply-To: Amir.Hameed@xerox.com X-list: oracle-l X-Virus-Scanned: amavisd-new at avenirtech.net Hi All, I am gathering some data on the amount of time that Oracle took to read and write (IO statistics). I am using v$filestat/x$kcfio for this purpose. I would like to know how reliable are the READTIM, WRITETIM, AVGIOTIM, MINIOTIM, MAXIORTM, and MAXIOWTM statistics. Here is what I am trying to achieve. I am in the process of implementing ODM (Oracle Disk Manager, from Veritas) in my lab. We are running Solaris 2.8 and Oracle 9.2.0.4 (64-bit). Since ODM offers RAW like performance features, my goal is to run tests as described below: -- Run a test with the buffered filesystem first and collect IO statistics then -- Enable ODM, increase the SGA size to ensure that what was cached in the filesystem buffer cache can now be cached in the SGA. Run the above test again, collect the IO statistics and then compare to see the improvement/degradation. Is there a better way to gather IO statistics (sar, iostat), etc than from v$filestat/x$kcfio ? Any help will be appreciated Thanks Amir -- http://www.freelists.org/webpage/oracle-l