RE: SQL*Net message from client ???

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 21 Jul 2004 18:31:33 -0500
Message-ID: <004501c46f7a$dc738cf0$e6ea8640@CVMLAP02>

If it's a few large event durations, then figure out what's taking so = long
outside your database (network, middle tier code path, user gone to the bathroom, etc.).

If it's a lot of small event durations, then visit your application = source
code with the idea in mind to eliminate unnecessary database calls. Some easy targets: parse calls that execute inside of loops, fetch calls that fetch one row at a time (arraysize=3D1), and exec calls that insert one = row at
a time.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 7/20 Cleveland, 8/10 Boston, 9/14 San =
Francisco
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas

Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Seema Singh
Sent: Wednesday, July 21, 2004 2:55 PM
To: oracle-l_at_freelists.org
Subject: SQL*Net message from client ???

Hi,
I have been noticing high wait event in "SQL*Net message from client" . Pl suggest how to fix this?
thx

Is your PC infected? Get a FREE online computer virus scan from McAfeeR=20 Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3D3963

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

----------------------------------------------------------------
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 Wed Jul 21 2004 - 18:29:57 CDT