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;