SQL*Net waits in a 10046 trace

  • From: "Schauss, Peter" <peter.schauss@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 22 May 2007 17:02:40 -0400

I am trying to shake out some performance issues in an application which
we are putting up (Peregrine Service Center) on Oracle, 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? 

Peter Schauss 

Other related posts: