Slow is a relative term. On average how big are the CLOB's? How many total bytes are you exporting? What is the average IO capacity of your target disk? Do a little math and determine if the elapsed time is really slow or just what it takes.
HTH -- Mark D Powell --
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi
Sent: Thursday, June 22, 2006 10:35 PM
To: oracle-l_at_freelists.org
Subject: ** table with clob slow
Hi,
We have a big table and it has one field with CLOB datatype. Doing an export on this table is very slow. I have tried with different buffer sizes of 2MB - 250MB. It is still slow. Any way to speed up export and other operations on the table like update,delete. Thanks for your help.
________________________________
Ring'em or ping'em. Make PC-to-phone calls as low as 1¢/min <http://us.rd.yahoo.com/mail_us/taglines/postman11/*http://us.rd.yahoo.com/evt=39666/*http://voice.yahoo.com> with Yahoo! Messenger with Voice.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 23 2006 - 08:20:34 CDT
