select
GROUP#, -- GROUP# NUMBER
THREAD#, -- THREAD# NUMBER
SEQUENCE#, -- SEQUENCE# NUMBER
ISCURRENT, -- ISCURRENT VARCHAR2(3)
"CURRENT", -- CURRENT VARCHAR2(3)
FIRST_CHANGE# -- FIRST_CHANGE# NUMBER
from
GV$ARCHIVE
where
inst_id = USERENV('Instance')