oracle 查看表占用空间大小

 查看当前用户

select SEGMENT_NAME as TABLE_NAME,BYTES/1024/1024 as 大小MB 
from USER_SEGMENTS 
where SEGMENT_TYPE='TABLE' 
order by BYTES desc;


select * 
from USER_SEGMENTS 
order by BYTES desc;

查看所有用户

 

select OWNER,SEGMENT_NAME as TABLE_NAME,BYTES/1024/1024 as 大小MB
from DBA_SEGMENTS
where SEGMENT_TYPE='TABLE'
order by OWNER,BYTES desc;


select *
from DBA_SEGMENTS
order by OWNER,BYTES desc;