oracle 查看表占用的空间大小

select t.owner,
t.tablespace_name,
t.segment_name,
--'drop table '||t.segment_name||' purge;',
t.segment_type,
sum(t.bytes / 1024 / 1024 / 1024) "user_g"
from dba_segments t
where 1=1
and t.segment_type like '%TABLE%'
and t.TABLESPACE_NAME like'%表空间%'
and t.segment_name like upper('%表名%')
and t.segment_type like upper('%表类型：普通表、分区表%')
and t.owner = '所属用户'
group by owner, t.tablespace_name, t.segment_name, t.segment_type
order by "user_g" desc,t.segment_name;