HOW TO KNOW THE DATA PUMP IS LAGGING OR WHICH PROCESS IS EXECUTING WITH TIME ELAPSED :

While importing a dump file, sometimes it takes too long and seems to be “hanging” and processing something unknown in the background, or queuing for something. As a DBA, you HAVE NOT wait “until it finishes”. You have to try to find out the solution.


This is the command I run to import the dump file into the new database:

impdp system/sys@orcl directory=data_pump_dir dumpfile=dd.dmp logfile=dd1.log remap_schema=temp:champ metrics=y

--------

Import: Release 11.2.0.1.0 - Production on Sat Jul 4 14:59:38 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/********@orcl directory=data_pump_dir dumpfile=dd.dmp logfile=dd1.log remap_schema=temp:champ metrics=y
Processing object type SCHEMA_EXPORT/USER
     Completed 1 USER objects in 0 seconds
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
     Completed 1 SYSTEM_GRANT objects in 0 seconds
Processing object type SCHEMA_EXPORT/ROLE_GRANT
     Completed 3 ROLE_GRANT objects in 0 seconds
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
     Completed 1 DEFAULT_ROLE objects in 0 seconds
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
     Completed 1 PROCACT_SCHEMA objects in 0 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE
     Completed 1 TABLE objects in 0 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "CHAMP"."TBL_READ_ONLY"                     5.015 KB       1 rows
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
     Completed 1 TRIGGER objects in 0 seconds
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 14:59:46


--------

Thanks.
NJ