These metrics include the current space used all flashback logs
Monitoring Flashback Database (continued)
BEGIN_TIM END_TIME FLASHBACK_DATA DB_DATA REDO_DATA EST_FB_SZE--------- --------- -------------- ---------- ---------- ----------12-FEB-04 12-FEB-04 16384 0 24576 0 12-FEB-04 12-FEB-04 6594560 7471104 1533440 815923200 12-FEB-04 12-FEB-04 17235968 12361728 5150720 839467008 12-FEB-04 12-FEB-04 311648256 37249024 10272768 855195648
|
---|
SQL> SELECT name, space_limit AS quota,
2 space_used AS used,
3 space_reclaimable AS reclaimable, 4 number_of_files AS files
5 FROM v$recovery_file_dest ;
NAME QUOTA USED RECLAIMABLE FILES | ||
---|---|---|
----------- | ||
/u01/flash_recovery_area 5368709120 2509807104 203386880 226 |