oracle 19c awr 丢失 i/o信息

最近在分析19c的awr报告时发现i/o信息丢失

 以下3张表WRH$_FILESTATXS, WRH$_DATAFILE and WRH$_TEMPSTATXS 没刷新导致I/O丢失,使用以下办法刷新
exec dbms_workload_repository.modify_table_settings(table_name  => 'WRH$_FILESTATXS', flush_level => 'TYPICAL');
exec dbms_workload_repository.modify_table_settings(table_name  => 'WRH$_DATAFILE', flush_level => 'TYPICAL');
exec dbms_workload_repository.modify_table_settings(table_name  => 'Tempfile Group', flush_level => 'TYPICAL');
exec dbms_workload_repository.modify_table_settings(table_name  => 'WRH$_TEMPSTATXS', flush_level => 'TYPICAL');

参考mos Bug 25416731 - tablespace io statistics missing from awr report (Doc ID 25416731.8)



原文地址:https://www.cnblogs.com/omsql/p/15511553.html