RE: SQL*Net waits in a 10046 trace

Without the blob column, the query returns instantly.  

• Peter Schauss

  ---

From: Guang Mei [mailto:GuangMei_at_crd.com] Sent: Wednesday, May 23, 2007 9:16 AM
To: Schauss, Peter; David Sharples
Cc: oracle-l_at_freelists.org
Subject: RE: SQL*Net waits in a 10046 trace

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.  

• Peter Schauss

--
http://www.freelists.org/webpage/oracle-l