I have impdp jobs in Oracle 12c that take a looooong time to import the index/index objects.
Case in point. In an impdp job the entire job had an elapsed time of 01:25:59
but the step Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX step
Completed 3388 INDEX objects in 4179 seconds which is 1:09:39.
Here is the impdp command
impdp user/password directory=ext_dp dumpfile=gr.dmp logfile=gr-imp.log
job_name=gr schemas=grprod REMAP_SCHEMA=grprod:grdebug table_exists_action=replace
version=12.1.0 transform=oid:n metrics=Y
Both the source SID and the Destination SID are Oracle12c, stand alone, enterprise edition instances
Are there any tuning parameters in Oracle or in the IMPDP command?
Thank you.