It looks like to processed, Oracle.exe and pmdtm.exe are locking tables and preventing loads from running.
What are these apps and aside from rebooting the machine, what can be done to clear the lock?
select * from dba_dml_locks@sdwt where session_id in
(
select session_id from GV$LOCKED_OBJECT@sdwt
)
SESSION_ID OWNER NAME MODE_HELD MODE_REQUESTED LAST_CONVERT BLOCKING_OTHERS 7 DW_MGR PO_HEADER_CURR_STG Row-X (SX) None 4985 Not Blocking 33 DW_MGR PO_HEADER_CURR_STG Row-X (SX) None 1356 Not Blocking 33 DW_MGR PO_LINES_CURR_STG Row-X (SX) None 1356 Not Blocking 33 DW_MGR PO_DISTRIBUTIONS_CURR_STG Row-X (SX) None 1356 Not Blocking 7 DW_MGR PO_LINES_CURR_STG Row-X (SX) None 4984 Not Blocking 7 DW_MGR PO_DISTRIBUTIONS_CURR_STG Row-X (SX) None 4984 Not Blocking
SELECT PROGRAM, MACHINE, SID
FROM V$SESSION
WHERE sid IN (select session_id from GV$LOCKED_OBJECT@sdwt)
PROGRAM MACHINE SID pmdtm.exe NA\USEARVP829 29 pmdtm.exe NA\USEARVP829 34 ORACLE.EXE USEARVP402 42