How to list all indexes in Oracle

To list all indexes in Oracle,

use the following SQL:

SELECT * FROM ALL_INDEXES WHERE INDEX_NAME LIKE 'IDX_TB_TEST%';

References:
http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_1069.htm#i1578369
http://stackoverflow.com/questions/3018094/how-to-find-all-indexes-and-their-columns-for-tables-views-and-synonyms-in-orac