GV$LOG
select
le.inst_id,              -- INST_ID NUMBER
le.lenum,                -- GROUP# NUMBER
le.lethr,                -- THREAD# NUMBER
le.leseq,                -- SEQUENCE# NUMBER
le.lesiz*le.lebsz,       -- BYTES NUMBER
ledup,                   -- MEMBERS NUMBER
decode                   -- ARCHIVED VARCHAR2(3)
  (bitand (le.leflg, 1), 0, 'NO', 'YES'),
decode                   -- STATUS VARCHAR2(16)
  (bitand (le.leflg, 24), 8, decode (bitand (le.leflg, 2), 2, 'INVALIDATED', '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),    -- FIRST_CHANGE# NUMBER
to_date                  -- FIRST_TIME 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 

home |  up  |  mailbox