189 8069 5689
SYS@orcl1> set lines 200
SYS@orcl1> col name for a50
SYS@orcl1> select * from v$recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 1.86 0 1 0
REDO LOG 0 0 0 0
ARCHIVED LOG 0 0 0 0
BACKUP PIECE 1.86 0 1 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 14.94 0 3 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.
SYS@orcl1> select * from v$flashback_database_log;
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE CON_ID
-------------------- ----------------------- ---------------- -------------- ------------------------ ----------
11415989 05-JAN-2018 18:58:23 2880 157286400 0 0
SYS@orcl1> select * from v$flashback_database_stat;
no rows selected
SYS@orcl1> select * from v$flashback_database_logfile;
NAME LOG# THREAD# SEQUENCE# BYTES FIRST_CHANGE# FIRST_TIME TYPE CON_ID
-------------------------------------------------- ---------- ---------- ---------- ---------- ------------- ----------------------- --------- ----------
+DATADG/ORCL/FLASHBACK/log_1.377.964637895 1 1 1 52428800 11416042 05-JAN-2018 18:58:17 NORMAL 0
+DATADG/ORCL/FLASHBACK/log_2.376.964637901 2 1 2 52428800 11427835 05-JAN-2018 22:01:05 NORMAL 0
+DATADG/ORCL/FLASHBACK/log_3.374.964648865 3 1 1 52428800 0 RESERVED 0