统计当前用户所有索引的大小--按大小倒序[@more@]SELECT t1.segment_name,t1.segment_type,t1.tablespace_name,SUM(t1.bytes)/1024/1024||'M' as "size",t2.table_owner,t2.table_name
FROM User_Segments t1,user_indexes t2
WHERE (t1.segment_type = 'INDEX' or t1.segment_type = 'INDEX PARTITION')
and t1.segment_name = t2.index_name(+)
GROUP BY t1.segment_name,t1.segment_type,t1.tablespace_name,t2.table_owner,t2.table_name
ORDER BY SUM(t1.bytes) DESC
FROM User_Segments t1,user_indexes t2
WHERE (t1.segment_type = 'INDEX' or t1.segment_type = 'INDEX PARTITION')
and t1.segment_name = t2.index_name(+)
GROUP BY t1.segment_name,t1.segment_type,t1.tablespace_name,t2.table_owner,t2.table_name
ORDER BY SUM(t1.bytes) DESC
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7691350/viewspace-1045156/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7691350/viewspace-1045156/