How to find UNUSABLE Index

Query:
======

set lines 300
set pages 3000


prompt Index Status:
select owner,index_name,TABLE_OWNER,TABLE_NAME,STATUS from dba_indexes where status='UNUSABLE';


Prompt Partition Index Status:
select INDEX_OWNER,INDEX_NAME,PARTITION_NAME,TABLESPACE_NAME,STATUS from dba_ind_partitions where STATUS='UNUSABLE';


Prompt Sub-partition Index Status:
select INDEX_OWNER,INDEX_NAME,PARTITION_NAME,STATUS,SUBPARTITION_NAME from dba_ind_subpartitions where STATUS='UNUSABLE';