SELECT idx.index_name, (SUM(bytes)/(1024*1024)) SIZE_IN_MB
FROM user_segments seg, user_indexes idx
WHERE idx.table_name = <my_table_name>
AND idx.index_name = seg.segment_name
GROUP BY idx.index_name;
FROM user_segments seg, user_indexes idx
WHERE idx.table_name = <my_table_name>
AND idx.index_name = seg.segment_name
GROUP BY idx.index_name;
No comments:
Post a Comment