RE: SQL*Net waits in a 10046 trace
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: "Guang Mei" <GuangMei@xxxxxxx>, "David Sharples" <davidsharples@xxxxxxxxx>
- Date: Wed, 23 May 2007 09:53:33 -0400
Without the blob column, the query returns instantly.
- Peter Schauss
________________________________
From: Guang Mei [mailto:GuangMei@xxxxxxx]
Sent: Wednesday, May 23, 2007 9:16 AM
To: Schauss, Peter; David Sharples
Cc: oracle-l@xxxxxxxxxxxxx
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@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
Other related posts:
