VIEW: SYS.V_$LOGFILE

Source

View Text - Preformatted

select "GROUP#","STATUS","TYPE","MEMBER","IS_RECOVERY_DEST_FILE","CON_ID" from v$logfile

View Text - HTML Formatted

SELECT "GROUP#"
, "STATUS"
, "TYPE"
, "MEMBER"
, "IS_RECOVERY_DEST_FILE"
, "CON_ID"
FROM V$LOGFILE