AWR DBA_HIST_SEG_STAT_OBJ / WRH$_SEG_STAT_OBJ after renaming objects
Hello everyone! I noticed a strange feature of AWR - after renaming the segments (tables or indexes) the information in the table
SYS.WRH $ SEGSTAT_OBJ not updated - it still contains the old names of objects. As a result, AWR report contains
old names of tables and indexes.
Does this mean that if an entry for the object with the particular OBJ# already exists in the table SYS.WRH $ SEGSTAT_OBJ,
it does not captured by the AWR again and AWR not carry out verification in case of changing object name?
Is this behavior normal or not, and how to fix this? RDBMS version - 10.2.0.4