GV$LOG definition in Oracle 8i / www.oracledba.ru
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, '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