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/CPUTI..
2022. 10. 19.