该问题为bug,可参考: Bug 25416731 - tablespace io statistics missing from awr report (Doc ID 25416731.8)
1.针对 Oracle 12.2.0.1 到18.x 版本, 可以下载bug 25416731 来修复
2.针对 Oracle 19.x, 可以通过 BUG 27871293 修复,如果无法修复,参考下面命令
也可运行以下命令 修复
set line 200 col table_name format a40 select * from dba_hist_table_settings where table_name in ('WRH$_FILESTATXS','WRH$_DATAFILE','Tempfile Group','WRH$_TEMPSTATXS'); 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');
设置后,awr报告会统计tablespace io相关信息