INDEX 용량확인 script

select owner,segment_name,segment_type,sum(bytes)/1024/1024 as MB

from dba_segments

where segment_type='INDEX'

and OWNER in ('스키마명','스키마명','스키마명')

group by owner,segment_name,segment_type;