1

Topic: Index unusable and suddenly valid

Greetings!
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 11.2.0.4.

2

Re: Index unusable and suddenly valid

Well, at first, "about such" request stupidly not  the local and partitioned indexes smile
And secondly, bulk copy-ins can include switch-off and the subsequent reorganization of indexes - i.e. speech here goes about someone's quite intelligent actions.
Besides, there are type operations alter table... move with the subsequent reorganization of indexes - too quite to itself intelligent process.