Index WRH$_SGASTAT_U has status UNUSABLE after upgrade to 12.2
Update 2016-04-26: this is new bug 25954054 – WRH$_SGASTAT_U BECOMING UNUSABLE STATE IN UPGRADED DB. After upgrading our OMR and AWRW instances from 12.1 to 12.2, our monitoring revealed that index SYS.WRH$_SGASTAT_U was becoming unusable at regular intervals. The first couple of times, we just rebuilt it in the hope that the problem would just …
Index WRH$_SGASTAT_U has status UNUSABLE after upgrade to 12.2 Read More »