v$log 与 gv$log

select GROUP#,
       THREAD#,
       SEQUENCE#,
       BYTES,
       MEMBERS,
       ARCHIVED,
       STATUS,
       FIRST_CHANGE#,
       FIRST_TIME
  from GV$LOG
 where inst_id = USERENV('Instance');

select le.inst_id,
       le.lenum,
       le.lethr,
       le.leseq,
       le.lesiz * le.lebsz,
       ledup,
       decode(bitand(le.leflg, 1), 0, 'NO', 'YES'),
       decode(bitand(le.leflg, 24),
              8,
              'CURRENT',
              16,
              'CLEARING',
              24,
              'CLEARING_CURRENT',
              decode(sign(leseq),
                     0,
                     'UNUSED',
                     decode(sign((to_number(rt.rtckp_scn) -
                                 to_number(le.lenxs)) * bitand(rt.rtsta, 2)),
                            -1,
                            'ACTIVE',
                            'INACTIVE'))),
       to_number(le.lelos),
       to_date(le.lelot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
  from x$kccle le, x$kccrt rt
 where le.ledup != 0
   and le.lethr = rt.rtnum
   and le.inst_id = rt.inst_id



SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
         1          1        730 1073741824          1 NO  INACTIVE             601324663 07-JUL-10
         2          2        888 1073741824          1 NO  INACTIVE             607868845 07-JUL-10
         7          1        731 1073741824          1 NO  INACTIVE             604961206 07-JUL-10
         8          1        732 1073741824          1 NO  INACTIVE             605086260 07-JUL-10
         9          1        733 1073741824          1 NO  CURRENT              605313033 07-JUL-10
        10          2        890 1073741824          1 NO  INACTIVE             607896695 08-JUL-10
        11          2        891 1073741824          1 NO  CURRENT              607909629 08-JUL-10
        12          2        889 1073741824          1 NO  INACTIVE             607881659 07-JUL-10

8 rows selected.

SQL> select * from gv$log;

   INST_ID     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
         1          1          1        730 1073741824          1 NO  INACTIVE             601324663 07-JUL-10
         1          2          2        888 1073741824          1 NO  INACTIVE             607868845 07-JUL-10
         1          7          1        731 1073741824          1 NO  INACTIVE             604961206 07-JUL-10
         1          8          1        732 1073741824          1 NO  INACTIVE             605086260 07-JUL-10
         1          9          1        733 1073741824          1 NO  CURRENT              605313033 07-JUL-10
         1         10          2        890 1073741824          1 NO  INACTIVE             607896695 08-JUL-10
         1         11          2        891 1073741824          1 NO  CURRENT              607909629 08-JUL-10
         1         12          2        889 1073741824          1 NO  INACTIVE             607881659 07-JUL-10
         2          1          1        730 1073741824          1 NO  INACTIVE             601324663 07-JUL-10
         2          2          2        888 1073741824          1 NO  INACTIVE             607868845 07-JUL-10
         2          7          1        731 1073741824          1 NO  INACTIVE             604961206 07-JUL-10

   INST_ID     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
         2          8          1        732 1073741824          1 NO  INACTIVE             605086260 07-JUL-10
         2          9          1        733 1073741824          1 NO  CURRENT              605313033 07-JUL-10
         2         10          2        890 1073741824          1 NO  INACTIVE             607896695 08-JUL-10
         2         11          2        891 1073741824          1 NO  CURRENT              607909629 08-JUL-10
         2         12          2        889 1073741824          1 NO  INACTIVE             607881659 07-JUL-10