Indexação em Tabelas/Colunas

Veja suas colunas indexadas

select  INDEX_NAME,TABLE_OWNER,TABLE_NAME,column_name
from  dba_ind_columns
order  by column_position

Veja suas Tabelas indexadas

select i.index_name
, i.tablespace_name
, ceil(s.bytes / 1048576) "Size MB"
from  dba_indexes i
, dba_segments s
where  i.index_name = s.segment_name
order  by 2, 1