(Oracle 12c) IMPDP Optimize speed & time
Hello,
I have Oracle 12 c (Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit) on Windows Server 2012 R2 Standard
32 GB RAM
2.66GHz (2 processors)
Oracle server contains one database with about 200 schemas.
I wonder how can i improve data pump import (impdp) speed/time. because sometimes it take about 2 hours during drop and import one schema.
memory parameters are setting like below
SQL> show parameter target;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_big_table_cache_percent_target string 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer