查看一个分区的大小

--查看分区
select *
from user_tab_partitions t
where t.table_name = upper('tdw_ft_active_d')

[@more@]--查看子分区信息
select *
from user_tab_subpartitions t
where t.table_name = upper('TDW_FT_CONTACT_H')
--查看一个分区的大小
select t.segment_name as "表名",t.owner as "用户名",sum(t.bytes)/1024/1024 as "表大小（单位：M）"
from dba_segments t
where t.partition_name in ('D_FT_CONTACT_H_20100701','D_FT_CONTACT_H_20100702','D_FT_CONTACT_H_20100703','D_FT_CONTACT_H_20100704','D_FT_CONTACT_H_20100705','D_FT_CONTACT_H_20100706','D_FT_CONTACT_H_20100707','D_FT_CONTACT_H_20100708','D_FT_CONTACT_H_20100709','D_FT_CONTACT_H_20100710','D_FT_CONTACT_H_20100711','D_FT_CONTACT_H_20100712','D_FT_CONTACT_H_20100713','D_FT_CONTACT_H_20100714','D_FT_CONTACT_H_20100715','D_FT_CONTACT_H_20100716','D_FT_CONTACT_H_20100717','D_FT_CONTACT_H_20100718','D_FT_CONTACT_H_20100719','D_FT_CONTACT_H_20100720','D_FT_CONTACT_H_20100721','D_FT_CONTACT_H_20100722','D_FT_CONTACT_H_20100723','D_FT_CONTACT_H_20100724','D_FT_CONTACT_H_20100725','D_FT_CONTACT_H_20100726','D_FT_CONTACT_H_20100727','D_FT_CONTACT_H_20100728','D_FT_CONTACT_H_20100729','D_FT_CONTACT_H_20100730','D_FT_CONTACT_H_20100731')
group by t.segment_name,t.owner
order by sum(t.bytes)/1024/1024 desc

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7490392/viewspace-1037431/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7490392/viewspace-1037431/