VIEW: SYS.V_$LOG_HISTORY

Source

View Text - Preformatted

select "RECID","STAMP","THREAD#","SEQUENCE#","FIRST_CHANGE#","FIRST_TIME","NEXT_CHANGE#","RESETLOGS_CHANGE#","RESETLOGS_TIME","CON_ID" from v$log_history

View Text - HTML Formatted

SELECT "RECID"
, "STAMP"
, "THREAD#"
, "SEQUENCE#"
, "FIRST_CHANGE#"
, "FIRST_TIME"
, "NEXT_CHANGE#"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "CON_ID"
FROM V$LOG_HISTORY