Import job is slow

Sometimes import becomes very slow and to improve performance it's better to clean purge sysaux table space.

Below are the simple sql's those can be executed to achieve this.

connect / as sysdba
SQL> @?/rdbms/admin/catnoawr.sql
SQL> @?/rdbms/admin/catawrtb.sql

Also check max size and autoextend of sysaux related datafiles. Those might be full and need to extend. But default setting of datafiles needs to change if above method does not work.

This helps when AWR performance is slow.I can safely remove the AWR metadata tables and recreate them.

There is a good link that will give more information for some of the basic impdp operations.

http://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/comment-page-1/

alternatively we can run impdp -help to find out all the options.

For export slow, follow below link
http://dbaharrison.blogspot.in/2014/07/datapump-export-is-slow-because-i-did.html