监控flash_recovery_area空间的使用

最新推荐文章于 2021-12-16 14:25:46 发布

clt3617

最新推荐文章于 2021-12-16 14:25:46 发布

阅读量160

点赞数

可以通过2个视图来监控flash_recovery_area空间的使用[@more@]

SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string g:oracleproduct10.2.0flash
_recovery_area
db_recovery_file_dest_size big integer 2G
SQL>
--=================================
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 23.19 0 13
BACKUPPIECE 9.36 0 2
IMAGECOPY 67.33 0 13
FLASHBACKLOG 0 0 0

6 rows selected.

SQL> select sum(PERCENT_SPACE_USED) from v$flash_recovery_area_usage;

SUM(PERCENT_SPACE_USED)
-----------------------
99.88

--===============================================
SQL> desc v$recovery_file_dest
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
SPACE_LIMIT NUMBER
SPACE_USED NUMBER
SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER

SQL> col name format a45
SQL> select * from v$recovery_file_dest;

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
--------------------------------------------- ----------- ---------- ----------------- ---------------
g:oracleproduct10.2.0flash_recovery_area 2147483648 2144909312 0 28

SQL> select round(100*(a.space_used/space_limit),2) from v$recovery_file_dest a;

ROUND(100*(A.SPACE_USED/SPACE_LIMIT),2)
--=============================================
99.88

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1047783/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1047783/