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')