GV$ARCHIVE definition in Oracle 10g / www.oracledba.ru
GV$ARCHIVE
select
le.inst_id, -- INST_ID NUMBER
le.lenum, -- GROUP# NUMBER
le.lethr, -- THREAD# NUMBER
le.leseq, -- SEQUENCE# NUMBER
decode -- ISCURRENT VARCHAR2(3)
(bitand (le.leflg, 8), 0, 'NO', 'YES'),
decode -- CURRENT VARCHAR2(3)
(bitand (le.leflg, 8), 0, 'NO', 'YES'),
to_number (le.lelos) -- FIRST_CHANGE# NUMBER
from
x$kccle le,
x$kccdi di
where
bitand (di.diflg, 1) !=0 and le.ledup!=0 and bitand (le.leflg, 1) =0 and (to_number (le.lelos) <=to_number (di.difas) or bitand (le.leflg, 8) =0)