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@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh Sent: Wednesday, July 21, 2004 2:55 PM To: oracle-l@xxxxxxxxxxxxx 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------