Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXPDP Slow

user10437625Mar 13 2013 — edited Mar 14 2013

We have Windows 2008 R2 Server with Oracle 11.2.0.3 64-bit Enterprise

I am running a expdp on a Peoplesoft demo database (about 25 GB)) and it takes nearly 2 hours with or without compression. I have tried parallel option and it does not help much. I have run the expdp with the 'metrics' option:
;;;
Export: Release 11.2.0.3.0 - Production on Tue Mar 12 17:30:00 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "OPS$TALDPSORCL2\ORABATCH"."SYS_EXPORT_SCHEMA_01": /******** directory=DP_EXPORTS dumpfile=expddemo.dmp logfile=expddemo.log schemas=ps,sysadm compression=all exclude=statistics metrics=y
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.743 GB
Processing object type SCHEMA_EXPORT/USER
Completed 2 USER objects in 1 seconds
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Completed 1 SYSTEM_GRANT objects in 0 seconds
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Completed 2 ROLE_GRANT objects in 0 seconds
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Completed 2 DEFAULT_ROLE objects in 0 seconds
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Completed 1 TABLESPACE_QUOTA objects in 3 seconds
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Completed 2 PROCACT_SCHEMA objects in 30 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Completed 65691 TABLE objects in 1062 seconds
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed 4 OBJECT_GRANT objects in 2681 seconds
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Completed 68315 INDEX objects in 1250 seconds
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Completed 7993 INDEX objects in 197 seconds
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Completed 31475 VIEW objects in 146 seconds
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Completed 211 TRIGGER objects in 20 seconds

It takes a long time (nearly 45 minutes)for 'Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT'

Please help.
Regards