Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Net waits in a 10046 trace

SQL*Net waits in a 10046 trace

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Tue, 22 May 2007 17:02:40 -0400
Message-ID: <6591F529444E9748A546718B3D1A67010701A561@xcgv2605.northgrum.com>


I am trying to shake out some performance issues in an application which we are putting up (Peregrine Service Center) on Oracle 10.2.0.2.0, HPUX. One particular query retrieves 67 rows and runs for about 11 seconds. The trace file shows multiple pairs of "SQL*Net message to client"/"SQL*Net message from client" entries which seem to account for a good bit of the elapse time. One of the columns retrieved is a blob.

Is it possible that the multiple SQL*Net waits have something to do with transfering the blob data?

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 22 2007 - 16:02:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US