Database Utilities (MOSC)

MOSC Banner

Expdp extremely slow

edited May 26, 2016 11:21AM in Database Utilities (MOSC) 6 commentsAnswered ✓

Hi Everyone,

My Oracle Version: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

The patch:  "Database Patch Set Update : 12.1.0.2.160119 (21948354)"

I am facing a problem in expdp, is very slow, is not related to hardware, I did tests and the performance is good

I believe it may be related to the number of indexes and tables of the exported schema.

SQL> select count(*) from all_tables where OWNER='LOGIX';

  COUNT(*)

----------

    163867

SQL> select count(*) from all_indexes where OWNER='LOGIX';

  COUNT(*)

----------

     74766

But I have this instance in another environment (lower hardware) with 10.2.0.5 version and everything runs ok. Run expdp of only one table the performance is perfect

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center