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: Export of CLOB too slow ?!!

RE: Export of CLOB too slow ?!!

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 24 Aug 2006 11:15:20 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5ADF2@ex2.ms.polyserve.com>

 

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-l
Received on Thu Aug 24 2006 - 13:15:20 CDT

Original text of this message

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