Re: Export of CLOB too slow ?!!
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: premjhere@xxxxxxxxx
- Date: Thu, 24 Aug 2006 12:51:28 -0500 (CDT)
Are you running it over a (slow) network?
CLOBs are exported a row at a time instead of a block at a time, so there
is a network round trip for each row. I learned this when I tried to
export a database in Japan from the U.S. over a very slow network link. A
small database, much smaller than yours would have taken over 20 hours.
Keith
> Friends,
>
> 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.
>
> 15 million rows are with CLOB data of the total 23 million rows
> to be exported.
>
> Is the export expected to be this slow on such a hardware ?
> Read on the net that splitting the big clob tables based on primary key
> using QUERY parameter (of export) and running them in parallel
> would help. Is this is a proven method ? I need to test it though.
>
> Any other suggestions to speed up this export ? Thanks in advance.
>
> Regards | Jp.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
