[资源分享]oracle统计某表占用容量

select
 b.owner, 
 a.table_name, 
 a.num_rows, 
 b.bytes/1024/1024||'M' as table_size 
 from dba_all_tables a 
 join dba_segments b 
 on a.owner = b.owner 
 and a.table_name = b.segment_name 
 where  a.table_name = 'TC_DOC_FILE' --需要查询的表
 and b.segment_type IN ('TABLE','TABLE PARTITION','TABLE SUBPARTITION','LOBSEGMENT') 
 ORDER BY owner,table_size DESC;