impdp inactive for hours
Hi all,
on 11.2.0.4
I ran the following command line
impdp system/*****@orcl FULL=Y DUMPFILE=EXP_FUL_ORCL.DMP
but seems hunging since several hours ego. Nothing added to alertlog. The last line in it is :
Replication after-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully
And in v$session :
select module ,status, sql_id, event, seconds_in_wait from v$session where program='impdp.exe'
MODULE | STATUS SQL_ID | EVENT | SECONDS_IN_WAIT |
---------------------------------------------------------------- -------- ------------- ---------------------------------------------------------------- ---------------------------------------
impdp.exe | INACTIVE 8c0syt8yv0qvn SQL*Net message from client | 3499 |
1 rows selected
select BLOCKING_INSTANCE, BLOCKING_SESSION from v$session where program='impdp.exe'