Oracle查询当前表空间各数据表的大小

 

--查询当前表空间各数据表的大小且降序排列

select A.Segment_Name, A.size_total || 'M'

from (Select Segment_Name, Sum(bytes) / 1024 / 1024 size_total

From User_Extents

Group By Segment_Name) A

order by size_total desc