重庆思庄Oracle、Redhat认证学习论坛

标题: 等待事件:Recovery Area: computing obsolete files [打印本页]

作者: 郑全    时间: 2024-1-24 15:49
标题: 等待事件:Recovery Area: computing obsolete files
awr报告中,发现一个等待事件:
Recovery Area: computing obsolete files



MOS上有几篇文章,主要是说保持跟踪即可,也有一篇,19.8的,需要注意,给了解决办法,参考一下:



RMAN backup Running Slow With Wait Event Recovery Area: computing obsolete files (Doc ID 2764973.1)

In this Document
Symptoms
Changes
Cause
Solution
References

APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
Rman archivelog job is running slow with observed wait event: recovery area: computing obsolete files

CHANGES
Db Upgraded to 19.8

CAUSE
Dictionary stats were invalid after upgrade.


SOLUTION
Please gather the dictionary stats using below

SQL> EXEC DBMS_STATS.DELETE_DICTIONARY_STATS;

SQL> EXEC DBMS_STATS.gather_dictionary_stats;








欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2