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 1042280
1 10 1042280 22-JUN-16 1042461
1 11 1042461 22-JUN-16 1042469
