Oracle 10g 如何檢查db_recovery 所使用的量

相關的Data Dictionary Views

V$RECOVERY_FILE_DEST

This view is the main source and contains the following columns:

SPACE_LIMIT	how much space has been allocated to the flash recovery area
SPACE_USED	space occupied
SPACE_RECLAIMABLE	how much space you can reclaim by getting rid of obsolete and redundant files in the flash recovery area.
NUMBER_OF_FILES	number of files

V$FLASH_RECOVERY_AREA_USAGE

This view provides information about the flash recovery area disk space usage. Following is its main columns:

FILE_TYPE	the type of the file and can have any of the following values: controlfile, onlinelog, archivelog, backuppiece, imagecopy, flashbacklog
PERCENT_SPACE_USED	This represents the disk space used by the file type, in percentage.
PERCENT_SPACE_RECLAIMABLE	this represents the percentage of disk space reclaimable from the file type after deleting any obsolete or redundant files, and files backed up to a tertiary device.