等待事件：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;