SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ---------- ------
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE#
-------------------------------- ------------- -------------- ------------
NEXT_TIME
--------------
1 1 16 52428800 512 1 NO
INACTIVE 1245881 22-5月 -18 1279088
23-5月 -18
3 1 18 52428800 512 1 NO
CURRENT 1299400 24-5月 -18 2.8147E+14
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ---------- ------
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE#
-------------------------------- ------------- -------------- ------------
NEXT_TIME
--------------
2 1 17 52428800 512 1 NO
INACTIVE 1279088 23-5月 -18 1299400
24-5月 -18