Flashback status and restore points

1CLEAR COLUMNS2SET LINESIZE 140 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN flashback_on     HEADING "FLASHBACK"         FORMAT A184COLUMN log_mode         HEADING "LOG MODE"          FORMAT A125COLUMN oldest_flashback HEADING "OLDEST POSSIBLE"   FORMAT A166COLUMN retention_target HEADING "TARGET MIN"        FORMAT 999,9907COLUMN flashback_mb     HEADING "FLASHBACK LOGS MB" FORMAT 99,999,9908COLUMN name             HEADING "RESTORE POINT"     FORMAT A309COLUMN scn              FORMAT 9999999999999999910COLUMN created          FORMAT A1611COLUMN guaranteed       HEADING "GUARANTEED"        FORMAT A1012COLUMN storage_mb       HEADING "STORAGE MB"        FORMAT 99,999,99013 14SELECT flashback_on, log_mode FROM v$database;15 16SELECT TO_CHAR(oldest_flashback_time, 'YYYY-MM-DD HH24:MI') AS oldest_flashback,17       retention_target,18       ROUND(flashback_size / 1048576) AS flashback_mb19FROM v$flashback_database_log;20 21SELECT name, scn,22       TO_CHAR(time, 'YYYY-MM-DD HH24:MI') AS created,23       guarantee_flashback_database AS guaranteed,24       ROUND(storage_size / 1048576) AS storage_mb25FROM v$restore_point26ORDER BY time;