Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export of CLOB too slow ?!!
I/O intensive work. Can you tell us a bit about the storage and runtime I/O characteristic you've monitored?
>>>
>>>This is on oracle 10.2.0.1 / AIX5.3L on IBM P595 machine
>>>which has got 64 CPUs and ~200G RAM.
>>>
>>>Export of a 100GB schema in this database takes 11+ hours.
>>>The reason export being slow , I feel , is 32 out 118 tables
>>>have CLOB column. And the largest 2 tables (with CLOB) have
>>>7 million (20G in size) and 3.5 million (10G in size) rows
>>>respectively.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 24 2006 - 13:15:20 CDT