Oracle 롤백 타임 구하기 (Rollback remaining time)

---

Oracle 롤백 타임 구하기 (Rollback remaining time)

---

 

Rollback Time 구하기

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';

SELECT USN
     , SLT
     , SEQ
     , STATE
     , PID
     , CPUTIME
     , UNDOBLOCKSDONE
     , UNDOBLOCKSTOTAL
     , UNDOBLOCKSTOTAL - UNDOBLOCKSDONE TO_DO
     , ROUND(UNDOBLOCKSDONE/UNDOBLOCKSTOTAL*100, 2) PERCENT
     , DECODE(CPUTIME, 0, 'unknown', SYSDATE+(((UNDOBLOCKSTOTAL - UNDOBLOCKSDONE)/(UNDOBLOCKSDONE/CPUTIME))/86400)) FINISH_TIME
  FROM V$FAST_START_TRANSACTIONS;