Indexes Sizes

SELECT idx.index_name, SUM(bytes)
  FROM dba_segments seg,
       dba_indexes  idx
 WHERE idx.table_owner = 'TRANSSENDOPS_PRD'
   AND idx.table_name in (select * from all_object_usage)
   AND idx.owner       = seg.owner
   AND idx.index_name  = seg.segment_name
 GROUP BY idx.index_name;