监控flash_recovery_area的使用情况

发布时间：2020-12-15 17:25:43 所属栏目：百科来源：网络整理

导读：监控flash_recovery_area的使用情况可以查询2个视图: 1.V$FLASH_RECOVERY_AREA_USAGE:displays usage information about flashback recovery areas SQL ? select ? * from ?v$flash_recovery_area_usage; FILE_TYPE????????????PERCENT_SPACE_USED?PERCENT_S

监控flash_recovery_area的使用情况可以查询2个视图:

1.V$FLASH_RECOVERY_AREA_USAGE:displays usage information about flashback recovery areas

SQL > ? select ? * from ?v$flash_recovery_area_usage;

FILE_TYPE????????????PERCENT_SPACE_USED?PERCENT_SPACE_RECLAIMABLE?NUMBER_OF_FILES

-- ------------------?------------------?-------------------------?---------------

CONTROL? FILE ?????????????????????????? 0 ????????????????????????? ???????????????

REDO? LOG ??????????????????????????????

ARCHIVED? ?????????????????????? 30.81 ?????????????? 61

BACKUP ?PIECE?????????????????????????? IMAGE ?COPY????????????????????????????

FLASHBACK? ????????????????????? 12.99 8.54 70 FOREIGN ?ARCHIVED? ??????????????????

已选择7行。

SQL ? sum (PERCENT_SPACE_USED)? ?v$flash_recovery_area_usage;

SUM (PERCENT_SPACE_USED)

--------------------- ??????????????????? 43.8

2.V$RECOVERY_FILE_DEST:displays information about the disk quota and current disk usage in the flash recovery area.

?V$RECOVERY_FILE_DEST;

NAME?????????????????????????????????????SPACE_LIMIT?SPACE_USED?SPACE_RECLAIMABLE?NUMBER_OF_FILES

--------------------------------------?-----------?----------?-----------------?---------------

/ opt oracle flash_recovery_area??????????? 8589934592 3762538496 ????????? 733315072 ????????????? 131

SQL round ( 100 (a.space_used space_limit), 2 )? ?v$recovery_file_dest?a;

ROUND (A.SPACE_USED SPACE_LIMIT),0)">)

------------------------------------- ??????????????????????????????????? 43.8

--本篇文章转自：http://www.blogjava.net/KingKong/archive/2011/05/30/351332.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!