Tuesday, May 26, 2009

Checking the space usage of recovery area

SQL> set linesize 150
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;

NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area
6442450944 3482205184 0 73


SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 54.79 0 74
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

No comments:

Post a Comment