查看当前用户每个表占用空间的大小:
select segment_name,sum(bytes)/1024/1024 from user_extents group by segment_name
查看每个表空间占用空间的大小:
select tablespace_name,sum(bytes)/1024/1024 from dba_segments group by tablespace_name
查看当前用户每个表占用空间的大小:
select segment_name,sum(bytes)/1024/1024 from user_extents group by segment_name
查看每个表空间占用空间的大小:
select tablespace_name,sum(bytes)/1024/1024 from dba_segments group by tablespace_name