RE: Export of CLOB too slow ?!!
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Aug 2006 11:15:20 -0700
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
