Dead Transaction 조회

- 정상적이지 않은 DML 실행시 다음 쿼리 조회후 확인

SELECT B.NAME USEG,
       B.INST# INSTID, 
       B.STATUS$ STATUS, 
       A.KTUXEUSN XID_USN,
       A.KTUXESLT XID_SLOT,
       A.KTUXESQN XID_SEQ,
       A.KTUXESIZ UNDOBLOCKS,
       A.KTUXESTA TXSTATUS
  FROM X$KTUXE A,UNDO$ B
 WHERE A.KTUXECFL LIKE '%DEAD%'
   AND A.KTUXEUSN = B.US#;

alter system dump undo header '_SYSSMU289_1564695500$';

Transaction recovery: lock conflict caught and ignored