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: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 23 Jun 2006 11:25:16 -0700 (PDT)
Message-ID: <20060623182516.26796.qmail@web60717.mail.yahoo.com>


Mark,

    Yes. It is very slow in comparison to others :table with clob is aorund 1 GB. There are other tables in that range. for export : if i kick off export of other tables and this table with clob simultaneosly then what happens is :    

  table with clob is about 20 times slower. For similar size table. I think other operations like delete are also slow on this table. Thanks

"Powell, Mark D" <mark.powell_at_eds.com> wrote:

      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 with Yahoo! Messenger with Voice.                          

Sneak preview the all-new Yahoo.com. It's not radically different. Just radically better.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 23 2006 - 13:25:16 CDT

Original text of this message

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