DBA Data[Home] [Help]

VIEW: SYS.V_$FLASHBACK_DATABASE_LOGFILE

Source

View Text - Preformatted

select "NAME","LOG#","THREAD#","SEQUENCE#","BYTES","FIRST_CHANGE#","FIRST_TIME","TYPE","CON_ID" from v$flashback_database_logfile
View Text - HTML Formatted

SELECT "NAME"
, "LOG#"
, "THREAD#"
, "SEQUENCE#"
, "BYTES"
, "FIRST_CHANGE#"
, "FIRST_TIME"
, "TYPE"
, "CON_ID"
FROM V$FLASHBACK_DATABASE_LOGFILE