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

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

Re: SQL*Net waits in a 10046 trace

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 22 May 2007 23:05:28 +0100
Message-ID: <be592d550705221505q7b9f848el1ddb12f57a1750b6@mail.gmail.com>


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_at_ngc.com> 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 22 2007 - 17:05:28 CDT

Original text of this message

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