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: ** table with clob slow

RE: ** table with clob slow

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 23 Jun 2006 09:20:34 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410507A861FD@usahm236.amer.corp.eds.com>


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

Original text of this message

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