Re: SQL*Net waits in a 10046 trace
- From: "David Sharples" <davidsharples@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Tue, 22 May 2007 23:05:28 +0100
how long does it take for the blob to be sent across the network to the
application?
On 22/05/07, Schauss, Peter <peter.schauss@xxxxxxx> wrote:
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.
Other related posts:
