I have a lot of database, a ton of partitioned tables and many processes running on them.
In a couple of occasions I hade problems for unusable indexes or partitions of them. A bugged procedure, or a human error of the dba.
I'd like to rise an alarm when an index became unusable.
Oracle is version 11.2, new installations 12. All enterprise.
Grid control is 12c.
I also have nagios on every machine
The only way I found is to use a nagios plugin to run custom query on database. Is this the best way?