RE: SQL*Net waits in a 10046 trace

From: "Guang Mei" <GuangMei@xxxxxxx>
To: <peter.schauss@xxxxxxx>, "David Sharples" <davidsharples@xxxxxxxxx>
Date: Wed, 23 May 2007 09:16:13 -0400

How long would it take if you remove the blob column from your select
list?

 

Guang

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, Peter
Sent: Wednesday, May 23, 2007 9:04 AM
To: David Sharples
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: SQL*Net waits in a 10046 trace

 

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

Follow-Ups:

RE: SQL*Net waits in a 10046 trace
From: Schauss, Peter

References:
- SQL*Net waits in a 10046 trace
  - From: Schauss, Peter
- Re: SQL*Net waits in a 10046 trace
  - From: David Sharples
- RE: SQL*Net waits in a 10046 trace
  - From: Schauss, Peter

RE: SQL*Net waits in a 10046 trace

Other related posts: