VIEW: SYS.V_$ARCHIVE

Source

View Text - Preformatted

select "GROUP#","THREAD#","SEQUENCE#","ISCURRENT","CURRENT","FIRST_CHANGE#","CON_ID" from v$archive

View Text - HTML Formatted

SELECT "GROUP#"
, "THREAD#"
, "SEQUENCE#"
, "ISCURRENT"
, "CURRENT"
, "FIRST_CHANGE#"
, "CON_ID"
FROM V$ARCHIVE