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