DBA Data[Home] [Help]

VIEW: SYS.GV_$FLASHBACK_DATABASE_LOG

Source

View Text - Preformatted

select "INST_ID","OLDEST_FLASHBACK_SCN","OLDEST_FLASHBACK_TIME","RETENTION_TARGET","FLASHBACK_SIZE","ESTIMATED_FLASHBACK_SIZE","CON_ID" from gv$flashback_database_log
View Text - HTML Formatted

SELECT "INST_ID"
, "OLDEST_FLASHBACK_SCN"
, "OLDEST_FLASHBACK_TIME"
, "RETENTION_TARGET"
, "FLASHBACK_SIZE"
, "ESTIMATED_FLASHBACK_SIZE"
, "CON_ID"
FROM GV$FLASHBACK_DATABASE_LOG