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: -
After rebuilding these index partitions, I restarted Germain for the changes to take effect.
Related articles
Filter by label
There are no items with the selected labels at this time.