Skip to main content
Skip table of contents

Slow Germain dashboard caused by unusable oracle db indexes


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.


  • 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
  • TX_PK
  • After rebuilding these index partitions, I restarted Germain for the changes to take effect.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.