Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Net waits in a 10046 trace
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-lReceived on Tue May 22 2007 - 16:02:40 CDT