oracle 查看表所占空间大小

每个表的大小：

Select Segment_Name,Sum(bytes)/1024/1024 as MB From User_Extents Group By Segment_Name

表空间大小：

Select Tablespace_Name,Sum(bytes)/1024/1024 as MB From Dba_Segments Group By Tablespace_Name