select segment_name,owner,bytes from dba_segments where type='TABLE' or select segment_name,owner,bytes from user_segments type='TABLE'可以先看下表结构dba_segments user_segments type 或者 segment_type 记不清楚了
select * from dba_extents
Select Owner ,Segment_Name ,Segment_Type ,round((Sum(Bytes) / (1024 * 1024)),2) Size_Mb From Dba_Segments Where segment_type in ('TABLE','TABLE PARTITION' ) Group By Owner ,Segment_Name ,Segment_Type;查询结果是实际占用的空间,以兆为单位.
or
select segment_name,owner,bytes from user_segments type='TABLE'可以先看下表结构dba_segments user_segments type 或者 segment_type 记不清楚了
,Segment_Name
,Segment_Type
,round((Sum(Bytes) / (1024 * 1024)),2) Size_Mb
From Dba_Segments
Where segment_type in ('TABLE','TABLE PARTITION' )
Group By Owner
,Segment_Name
,Segment_Type;查询结果是实际占用的空间,以兆为单位.