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: Guang Mei <GuangMei_at_crd.com>
Date: Wed, 23 May 2007 09:16:13 -0400
Message-ID: <BB2F960B8F4F7C40A09F44F50CF40A780D87E9@mail3.crd.com>


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

Guang  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Wednesday, May 23, 2007 9:04 AM
To: David Sharples
Cc: oracle-l_at_freelists.org
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.  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 23 2007 - 08:16:13 CDT

Original text of this message

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