RE: expdp and clob ... any tricks to speed up?

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Wed, 20 Dec 2006 16:06:41 -0500
Message-ID: <009601c7247a$bf41a970$232b650a@nycwkswxp2829>

Here is one way of speeding things up:

Export: Release 10.2.0.3.0 - Production on Wednesday, 20 December, 2006 15:58:21

;;;

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": parfile=exp.par

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

;;; Export> EXIT_CLIENT

Total estimation using BLOCKS method: 167.0 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while ca

lling KUPF$FILE.WRITE_LOB []

ORA-19502: write error on file
"/ODATA/oradata/news/news_archive.dmp", blockno 5

(blocksize=4096)

ORA-27061: waiting for async I/Os failed

Linux Error: 6: No such device or address

Additional information: -1

Additional information: 4096

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 6228

PL/SQL Call Stack -----

object line object

handle number name

0x59641804 14916 package body SYS.KUPW$WORKER

0x59641804 6293 package body SYS.KUPW$WORKER

0x59641804 2339 package body SYS.KUPW$WORKER

0x59641804 6854 package body SYS.KUPW$WORKER

0x59641804 1259 package body SYS.KUPW$WORKER

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 15:59:33

ORA-39014: One or more workers have prematurely exited.

This has completed really quicky, performance was great. I'm about to congratulate Oracle by opening a TAR.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Wednesday, December 20, 2006 3:37 PM To: Oracle Discussion List
Subject: expdp and clob ... any tricks to speed up?

I have couple of tables that take long time to export using expdp (10gr1 db) because they have a clob in them. Are there any tricks to speed that up? parallel is of no use it won't use it.

ummm .. same with impdp ?
TIA
Rjamya

Got RAC?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 20 2006 - 15:06:41 CST