Shulou(Shulou.com)06/01 Report--

SYS@orcl1 > set lines 200SYS@orcl1 > col name for a50SYS@orcl1 > select * from v$recovery_area_usage FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID -CONTROL FILE 1.8601 0REDO LOG 0 000 0ARCHIVED LOG 0 0 0 0BACKUP PIECE 1.86 0 1 0IMAGE COPY 0 0 0 0FLASHBACK LOG 14.94 0 3 0FOREIGN ARCHIVED LOG 0 0 0 0AUXILIARY DATAFILE COPY 0 000 08 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 0SYS@orcl1 > select * from v$flashback_database_stat No rows selectedSYS@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 11 52428800 0 RESERVED 0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.