Troubleshooting impdp is hanging no progress

 impdp is hanging no progress

Hello jyothi babu -

Provide the following information

1. The command used when importing (include parfile if used)

2. What is it waiting on?
set pagesize 1000
set linesize 120
set feedback on
set timing on

col waiting_session heading "Wait|sid" format 99990
col event heading "Wait Event" format a20 trunc
col holding_session heading "Block|sid" format 99990
col serial# heading "Block|serial#" format 99990
col wprogram heading "Waiting Program" format a16 trunc
col bprogram heading "Blocking Program" format a16 trunc
col wmod heading "Waiting module" format a16 trunc
col bmod heading "Blocking module" format a16 trunc
col LOCK_ID1 heading "Object#" format 99999999

--specific to datapump
select dw.waiting_session, dw.holding_session,b.serial#,w.event, w.program wprogram,
        b.program bprogram, w.module wmod,b.module bmod, LOCK_ID1
from sys.dba_waiters dw, v$session w, v$session b
where dw.waiting_session = w.sid
and dw.holding_session = b.sid
and (w.module like 'Data Pump%'
or w.program like '%EXPDP%'
or w.program like '%IMPDP%')
order by dw.holding_session;

--specific to datapump
select sw.SID,sw.SEQ#,sw.EVENT, sw.WAIT_TIME,sw.SECONDS_IN_WAIT,sw.STATE,sw.P1TEXT,
       sw.P1,sw.P2TEXT,sw.P2,sw.P3TEXT,sw.P3 from V$SESSION_WAIT sw, v$session s
where sw.wait_class <> 'Idle'
and sw.sid=s.sid
and (s.module like 'Data Pump%'
or s.program like '%EXPDP%'
or s.program like '%IMPDP%');

3. Upload the alert log from the last time the database was started until now

4.Connect to the datapump job from a new session execute
expdp user/password attach=

Note: To get the job name:
select job_name, operation, job_mode, state from dba_datapump_jobs;

It will then return what the worker or workers are working on.
Collect this information ( cut and paste into the SR)

If you then wait 5 or 10 min and execute status
export> status

it will refresh the information and you can see if it is actually moving

Collect this information ( cut and paste into the SR)