重庆思庄Oracle、、PostgreSQL、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、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |