Expdp extremely slow
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