2 issues after Oracle 19C Upgrade on Windows Standard Edtion 2
I upgraded some DBs and i always have the same two issues
first: the alert log shows following message each day
2020-07-01T01:02:37.155354+02:00 Some indexes or index [sub]partitions of table SYS.WRH$_SYSMETRIC_HISTORY have been marked unusable
i found the following:
https://nenadnoveljic.com/blog/wrh_sysmetric_history_index/
but i'm not able to build a local index in SE2 because it's not possible without partitioning - but i think this should not bother me because i`m not allowed to use AWR anyway, true?
second there are plenty of trace files produced every minute:
*** 2020-06-30T09:27:20.263411+02:00