查询Oracle数据库中各对象占用空间情况



查询Oracle数据库中各对象占用空间情况：

select A.Segment_Name,Sum(A.bytes)/1024/1024 from user_extents A
where A.tablespace_name = 'RAS'
group by A.segment_name
order by Sum(A.bytes)/1024/1024 desc