oracle 数据库查询某库中某表所占空间信息
select
t.OWNER
, t.segment_name
, t.segment_type
, sum(t.bytes / 1024 / 1024) "占用空间(M)"
from
dba_segments t
where
t.segment_type = 'TABLE'
and OWNER = 'IPTV' --库名
and segment_name = 'T_IPTV_CONVEGE_HWVERSION' --表名
group by
OWNER
, t.segment_name
, t.segment_type;