col oldest_flashback_scn form 999999999999999999 select oldest_flashback_scn, oldest_flashback_time from v$flashback_database_log; col name form a30 col SPACE_LIMIT form 999,999,999,999,999 col SPACE_USED form 999,999,999,999,999 select * from v$recovery_file_dest;