Database 11.2.0.3
Red Hat Enterprise 6.4
I am running a datapump job and it appears to be stuck. It sits at importing a table constraint.
I found this query in another post to check the status:
SELECT
SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name,
to_char(LAST_ACTIVE_TIME,'MM/DD/YYYY HH24:MI:SS')
, rows_processed
, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes
, TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;
When I run the query it doesn't show that the job is doing anything. I am also checking OEM and it doesn't show anything for blocks. It shows waits for the session but it says the Wait Time is 0ms.
Here is what I see in the terminal:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TCFK2
Object Name: RISK_INS_SELL_PRD_ID_FK
Object Type: SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Completed Objects: 1,120
Worker Parallelism: 1
This is the command I ran:
impdp system/*****@devb full=Y STATUS=1 PARALLEL=4 DIRECTORY=imp dumpfile=EXP_01.DMP, EXP_02.DMP, EXP_03.DMP, EXP_04.DMP logfile=impdevb.log TABLE_EXISTS_ACTION=replace
I ran the same command a few days ago and the whole process only took 1 hour to complete. It has now been over 3 hours.
What else can I check to see if the import is working?