From oracle-l-bounce@freelists.org Wed Apr 21 22:33:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3M3XZY21623 for ; Wed, 21 Apr 2004 22:33:35 -0500 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 i3M3XZ621618 for ; Wed, 21 Apr 2004 22:33:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3469A72CD39; Wed, 21 Apr 2004 22:26:47 -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 17945-65; Wed, 21 Apr 2004 22:26:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A34272D688; Wed, 21 Apr 2004 22:26:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Apr 2004 22:25:34 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B230872D87C for ; Wed, 21 Apr 2004 22:25:33 -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 17439-80 for ; Wed, 21 Apr 2004 22:25:33 -0500 (EST) Received: from web60505.mail.yahoo.com (web60505.mail.yahoo.com [216.109.116.126]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 456CA72D50F for ; Wed, 21 Apr 2004 22:25:33 -0500 (EST) Message-ID: <20040422033713.8515.qmail@web60505.mail.yahoo.com> Received: from [24.136.220.254] by web60505.mail.yahoo.com via HTTP; Wed, 21 Apr 2004 20:37:13 PDT Date: Wed, 21 Apr 2004 20:37:13 -0700 (PDT) From: Michael Thomas Subject: Re: DBWn performs batched (multiblock) writes to improve efficiency To: oracle-l@freelists.org In-Reply-To: <20040421211958.GE5419@mladen.wangtrading.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3517 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mhthomas@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I don't know if this will help, but (of all places) I was reading in Lawson's Oracle Performance Tuning book on pg 288 about the Microsoft Platform SDK, and the APIMon utility. Supposedly APIMon, "One report shows the time and count for all functions called in the monitored application. A second report is like a debugging report, because it shows a trace of each call as it happens". Hmmmm....M$ right?...hidden api?...what functions?...low level I/O?...would have to prove it to myself first... This was not on my immediate list of things to do, so I don't know how/if it works. I'm sure I have the MS software somewhere in my stuff, so if no-one else can do maybe I can run a test later. :-) But, I like pd's recommendation about sysinternal as a possible source to check first. BTW, Lawson does _not_ mention any 'narrow focus' I/O disk utility like in Paul's post (very cool info). HTH. Regards, Mike Thomas --- Mladen Gogala wrote: Tanel, you want to take a look at the strace utility, which exists on both Linux and CYGWIN. It traces all system services that a prices makes, IO calls included. On Solaris, the same utility is called ... > maximum in my system), however I couldn't test this on 9.2 nor 10g beta on > my windows (the _dbwr_tracing seems to behave differently in these and I > don't have any utility to trace IO system calls in windows). -- __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------