Slow Germain dashboard caused by unusable oracle db indexes
Problem
Germain dashboard is very much dependent on the infrastructure that is runs on, especially the database and storage used by that database. It is common practice to make sure your database is running fast. In this case, Oracle database had a number of unusable DB Indexes which had to be rebuilt
Solution
- Using query: select * from dba_ind_partitions where STATUS = 'UNUSABLE';
I found several unusable index partitions. Rebuilt all partitions of the following indexes..
- AVL_PK
- EVT_PK
- TXN_EI_PK
- TX_PK
- Restart Germain