impdp taking 11 hours to complete for 90GB database
impdp taking 11 hours to complete for 90GB database
Database: oracle19.3.0.0
database size 90GB
OS: windows server 2012 R2
i am using impdp to build a clone of production database with new name.
when check with query it shows 99.99% completion and
take more than 10 hours at
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
following command is used in impdp
impdp 'sys/password@sid as sysdba' dir=data_pump_dir dumpfile=abc.dmp logfile=abc.log exclude=statistics exclude=packages table_exists_action=replace
Please suggest the solution for speeding up the impdp process.