Oracle: DBA_INDEXES

select
   ind.owner      , ind.index_name, ind.index_type,
   ind.table_owner, ind.table_name, ind.table_type,
   --
   ind.uniqueness,
   ind.join_index,
   ind.last_analyzed, ind.sample_size, ind.distinct_keys, ind.num_rows,
   ind.status       , ind.funcidx_status,
   ind.auto,
   ind.avg_data_blocks_per_key,
   ind.avg_leaf_blocks_per_key,
   ind.blevel,
   ind.buffer_pool,
   ind.cell_flash_cache,
   ind.clustering_factor,
   ind.compression,
   ind.constraint_index,
   ind.degree,
   ind.domidx_management,
   ind.domidx_opstatus,
   ind.domidx_status,
   ind.dropped,
   ind.duration,
   ind.flash_cache,
   ind.freelist_groups,
   ind.freelists,
   ind.generated,
   ind.global_stats,
   ind.include_column,
   ind.indexing,
   ind.ini_trans,
   ind.initial_extent,
   ind.instances,
   ind.iot_redundant_pkey_elim,
   ind.ityp_name,
   ind.ityp_owner,
   ind.leaf_blocks,
   ind.logging,
   ind.max_extents,
   ind.max_trans,
   ind.min_extents,
   ind.next_extent,
   ind.orphaned_entries,
   ind.parameters,
   ind.partitioned,
   ind.pct_direct_access,
   ind.pct_free,
   ind.pct_increase,
   ind.pct_threshold,
   ind.prefix_length,
   ind.secondary,
   ind.segment_created,
   ind.tablespace_name,
   ind.temporary,
   ind.user_stats,
   ind.visibility
from
   sys.dba_indexes ind;

select
-- ic.table_name,
   case when ic.column_position = 1 then ix.index_name         end index_name,
             ic.column_name,
   case when ic.column_position = 1 then ix.index_type         end index_type,
   case when ic.column_position = 1 then ix.table_type         end table_type,
   case when ic.column_position = 1 then iu.last_used          end last_used,
   case when ic.column_position = 1 then iu.total_access_count end total_access_count,
   ic.column_position
from
   dba_indexes      ix                                               join
   dba_ind_columns  ic on ix.owner      = ic.index_owner and
                          ix.index_name = ic.index_name         left join
   dba_index_usage  iu on ix.owner      = iu.owner       and
                          ix.index_name = iu.name
where
   ix.owner      = '...' and
   ix.table_name = '...'
order by
   ix.index_name,
   ic.column_position;