Re: Wait Stats

  • From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 26 Apr 2004 10:42:48 -0400

The same effect can be achieved with the slow client. I know of an application
whose users were constantly giving me calls about "slow database". Database
was waiting for the SQL*Net data. I tested the network by using ping and it 
as GB switch should: node alive, with 0ms response time. The application was 
one of
those three tier monstrosities, which was using iPlanet and iPlanet-based 
The explanation that I was given was the iPlanet 6.5 has had some serious 
with pooling, and that "it was hanging". The problem was in the application 
and a hanging client. Users were calling me because "database is slow today", 
in the same fashion as "there is something strange with the Force today". The 
thing  one can do is to profile the client application and see where the 
of time is spent. If that is a .NOT application, you should look no further.

On 04/26/2004 10:31:36 AM, Niall Litchfield wrote:
> Mladen writes
> > -----Original Message-----
> > From: oracle-l-bounce@xxxxxxxxxxxxx
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx 
> > <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] On Behalf Of Mladen Gogala
> > Sent: 26 April 2004 15:15
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: Re: Wait Stats
> >
> >
> > Have you tested the network with "ping"? Some platforms have
> > utility called "spray"
> > which helps you determine the network throughput. You cannot
> > make conclusions about
> > network based on Oracle wait events.
> Were the wait for SQL*Net more data from client I'd be quite tempted to 
> diagnose the problem as being  the network using Oracle wait events. Of 
> course it probably wouldn't convince a network admin.... 
> some places also limit or set at a low priority ICMP traffic
> Niall Litchfield
> Oracle DBA
> Audit Commission
> +44 117 975 7805 
> **********************************************************************
> This email contains information intended for
> the addressee only.  It may be confidential
> and may be the subject of legal and/or
> professional privilege.  Any dissemination,
> distribution, copyright or use of this
> communication without prior permission of
> the sender is strictly prohibited.
> **********************************************************************
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> FAQ is at
> -----------------------------------------------------------------

Mladen Gogala
Oracle DBA

This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege 
is waived or lost by any mistransmission.  If you receive this message in 
error, please immediately delete it and all copies of it from your system, 
destroy any hard copies of it and notify the sender.  You must not, directly or 
indirectly, use, disclose, distribute, print, or copy any part of this message 
if you are not the intended recipient. Wang Trading LLC and any of its 
subsidiaries each reserve the right to monitor all e-mail communications 
through its networks.
Any views expressed in this message are those of the individual sender, except 
where the message states otherwise and the sender is authorized to state them 
to be the views of any such entity.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: