RE: SQL*Net waits in a 10046 trace

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Wed, 23 May 2007 09:03:32 -0400
Message-ID: <6591F529444E9748A546718B3D1A67010701A565@xcgv2605.northgrum.com>

The query that I am working on retrieves 67 rows each of which has one blob column. It takes a total of 11 seconds.  

• Peter Schauss

  ---

From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Tuesday, May 22, 2007 6:05 PM
To: Schauss, Peter
Cc: oracle-l_at_freelists.org
Subject: Re: SQL*Net waits in a 10046 trace

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 Wed May 23 2007 - 08:03:32 CDT