Re: Wait Stats
- From: Fernando <fernandoluis@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Apr 2004 07:44:15 -0700
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
