v$loghist
Oracle/Oracle_reference
2016. 6. 22. 17:29
SQL> select * from v$loghist; THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM SWITCH_CHANGE# ---------- ---------- ------------- --------- -------------- 1 1 925702 21-JUN-16 956030 1 2 956030 21-JUN-16 956367 1 3 956367 21-JUN-16 971775 1 4 971775 21-JUN-16 988440 1 5 988440 21-JUN-16 998472 1 6 998472 21-JUN-16 1018673 1 7 1018673 21-JUN-16 1039361 1 8 1039361 22-JUN-16 1042273 1 9 1042273 22-JUN-16..