![nox stuck at 99 import nox stuck at 99 import](https://i.ebayimg.com/images/g/a~EAAOSwKj1f0G0C/s-l400.jpg)
The job is Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX so, I’m hoping it’s creating indexes. Well, in this particular case, the clue is on screen, in the log file, and noted above. The number of BLOCK_CHANGES should be increasing if the job was working correctly, shouldn’t it? Every session appears to be waiting for something to be broadcast. Hmm, looks like nothing is working at all. Select v.status, v.sid,v.serial#,io.block_changes,eventĪCTIVE 45 27 197679 PX Deq: Execute ReplyĪCTIVE 3 wait for unread message on broadcast channelĪCTIVE 614 89 15406 wait for unread message on broadcast channelĪCTIVE 70 wait for unread message on broadcast channelĪCTIVE 86 wait for unread message on broadcast channelĪCTIVE 1035 59 76471 wait for unread message on broadcast channel My job is running with parallel=4 in the parameter file, so that’s why there are 4 workers. So, we have the master session, and a few workers. Select owner_name, job_name, session_typeĭUNBARNOR SYS_IMPORT_FULL_01 DBMS_DATAPUMP
Nox stuck at 99 import full#
So, we see at least one full import job is running. Select owner_name, job_name, operation, job_mode Is the import actually running? Check DBA_DATAPUMP_JOBS to find out: The alert log for the database is of no help, as there are no errors or warnings logged there. Processing object type TABLE_EXPORT/TABLE/INDEX/INDEXīut hasn’t moved from there for what seems hours. You’ve watched the log file (or on screen messages) and it’s sitting at something like: You know the score, you are running an impdp and it looks to have hung up.