Slow Germain dashboard caused by unusable oracle db indexes
Problem
Germain's dashboard performance is highly dependent on the infrastructure it runs on, particularly the database and its associated storage. It's essential to ensure that your database is running efficiently. In this instance, the Oracle database had several unusable DB Indexes that needed to be rebuilt.
Solution
- I used the following query to identify unusable index partitions:
select * from dba_ind_partitions where STATUS = 'UNUSABLE';. This query revealed several unusable index partitions. I proceeded to rebuild all partitions of the following indexes:
- AVL_PK
- EVT_PK
- TXN_EI_PK
- TX_PK
- After rebuilding these index partitions, I restarted Germain for the changes to take effect.