From oracle-l-bounce@freelists.org Mon Apr 26 09:43:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3QEgow18108 for ; Mon, 26 Apr 2004 09:43:00 -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 i3QEge618066 for ; Mon, 26 Apr 2004 09:42:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1DA8772D3C2; Mon, 26 Apr 2004 09:33:25 -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 04918-31; Mon, 26 Apr 2004 09:33:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CF5C72D310; Mon, 26 Apr 2004 09:33:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Apr 2004 09:32:09 -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 82AA272D318 for ; Mon, 26 Apr 2004 09:31:54 -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 03129-79 for ; Mon, 26 Apr 2004 09:31:54 -0500 (EST) Received: from smtpout.mac.com (A17-250-248-45.apple.com [17.250.248.45]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 01F3172D327 for ; Mon, 26 Apr 2004 09:31:53 -0500 (EST) Received: from mac.com (smtpin08-en2 [10.13.10.153]) by smtpout.mac.com (Xserve/MantshX 2.0) with ESMTP id i3QEiHFv023818 for ; Mon, 26 Apr 2004 07:44:17 -0700 (PDT) Received: from [10.0.1.3] (user-10cmfgj.cable.mindspring.com [64.203.62.19]) (authenticated bits=0) by mac.com (Xserve/smtpin08/MantshX 3.0) with ESMTP id i3QEiGTK023035 for ; Mon, 26 Apr 2004 07:44:16 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v613) In-Reply-To: <000a01c42b96$b787de00$e20710ac@dba> References: <000a01c42b96$b787de00$e20710ac@dba> Content-type: text/plain; charset=US-ASCII Message-Id: <30E3769D-9790-11D8-9908-000A95A6AB02@mac.com> Content-Transfer-Encoding: 8bit From: Fernando Subject: Re: Wait Stats Date: Mon, 26 Apr 2004 07:44:15 -0700 To: oracle-l@freelists.org X-Mailer: Apple Mail (2.613) X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3768 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: fernandoluis@mac.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You can try to use a network analyzer ("sniffer"), like Sniffer itself (formerly from Network Associates), Application Vantage (Compuware), WildPackets, and also an open source one, Ethereal (www.ethereal.com) Some of this tools can rebuild the Oracle SQL from the traffic and they usually are very good at pointing the "guilty party", either an app or even a SQL. (Disclaimer: I used to work for Compuware in the AppVantage group) Fernando Pereira OpTier > all my low level 10046 trace shows predominantly SQL*Message to client > and from client waits ,I am of the opinion that Network is to be > blamed here ---------------------------------------------------------------- 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 -----------------------------------------------------------------