SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 140 52428800 1 YES INACTIVE
8873686 27-6月 -07
2 1 141 52428800 1 YES INACTIVE
8991897 27-6月 -07
3 2 149 52428800 1 YES INACTIVE
9030598 27-6月 -07
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
4 2 148 52428800 1 YES INACTIVE
8884090 27-6月 -07
5 1 142 52428800 1 YES INACTIVE
9176771 28-6月 -07
6 1 143 52428800 1 NO CURRENT
9279687 28-6月 -07
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
7 2 150 52428800 1 YES INACTIVE
9079467 27-6月 -07
8 2 151 52428800 1 NO CURRENT
9181028 28-6月 -07
已选择8行。