Oracle索引功能

Use below query to find out the invalid indexes:

SELECT index_name, status FROM dba_INDEXES WHERE status='UNUSABLE';
SELECT * from USER_INDEXES WHERE STATUS = 'INVALID';