Re: Wait Stats

From: Fernando <fernandoluis_at_mac.com>
Date: Mon, 26 Apr 2004 07:44:15 -0700
Message-Id: <30E3769D-9790-11D8-9908-000A95A6AB02@mac.com>

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_at_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
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 09:43:05 CDT