按用户查看所占用的数据库空间大小:
select owner,SEGMENT_TYPE,sum(BYTES)/1024/1024 as SIZE_M from dba_segments group by owner,SEGMENT_TYPE;
查看当前用户下所有表占用的空间情况:
select segment_name,tablespace_name,bytes,blocks from user_segments
按用户查看所占用的数据库空间大小:
select owner,SEGMENT_TYPE,sum(BYTES)/1024/1024 as SIZE_M from dba_segments group by owner,SEGMENT_TYPE;
查看当前用户下所有表占用的空间情况:
select segment_name,tablespace_name,bytes,blocks from user_segments