Indexes - Display segments sizing information for a all ixs of a table 
--
--  Name: show_tab_indexes_sizing.sql
--
--  Description: Indexes - Display segments sizing information for a all ix's of a table
--
--  Compatability: 7.3.x and above
--
--  Usage: @show_tab_indexes_sizing owner table_name
--
--
set linesize 133
set pages 40
--

column segment_name format a20
select segment_name,segment_type,initial_extent,next_extent,extents,bytes,blocks 
from dba_segments s
where segment_type = 'INDEX'
and owner = upper('&1')
and segment_name in 
   (select index_name from dba_indexes i where i.table_name = upper('&2') and i.owner = upper('&1'))
;