tags:

views:

13

answers:

0

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