check the dba_indexes. For column detail, do

SQL> desc dba_indexes


Sam