flashback

 select 'Flashback Enabled : ' || FLASHBACK_ON "Flashback Setup"
from v$database union
select 'DB Open Mode : ' || open_mode || ' - ' || log_mode
from v$database union
select 'Retention Target : ' || RETENTION_TARGET
from v$flashback_database_log union
select 'Available Flashback Size : ' || FLASHBACK_SIZE/1048576/1024 ||' GB'
from v$flashback_database_log union
select 'OLDEST_FLASHBACK_SCN : ' || OLDEST_FLASHBACK_SCN
from v$flashback_database_log union
select 'ESTIMATED_FLASHBACK_SIZE : ' || round(ESTIMATED_FLASHBACK_SIZE/1048576/1024,0) ||' GB'
from v$flashback_database_log order by 1