Re: Wait Stats

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 reacted 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 pooling. The explanation that I was given was the iPlanet 6.5 has had some serious problems with pooling, and that "it was hanging". The problem was in the application server and a hanging client. Users were calling me because "database is slow today", uttered in the same fashion as "there is something strange with the Force today". The best thing one can do is to profile the client application and see where the majority 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_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of Mladen Gogala
> > Sent: 26 April 2004 15:15
> > To: oracle-l_at_freelists.org
> > 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: 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
> -----------------------------------------------------------------
>

-- 
Mladen Gogala
Oracle DBA



Note:
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: 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
-----------------------------------------------------------------