Topic: Index unusable and suddenly valid
That that I do not understand zabbix basis on a subject indexes, such approximately request: SELECT owner || ' ' || index_name || ' ' || tablespace_name nm FROM dba_indexes WHERE status = ' UNUSABLE ' and it is not empty, sends the message. This request is fulfilled each 5 minutes and if the result is empty the message that everything is all right comes. Here I also do not understand as so? The index itself is treated? oracle 22.214.171.124.