Skip to main content
Skip table of contents

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



JavaScript errors detected

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

If this problem persists, please contact our support.