Oracle 数据库表、表空间大小统计

1、查找特定表大小

select round(BYTES/1024/1024,2)||'M' from Dba_Segments where segment_name=upper('表名')；

2、查找数据库中占用空间较大的对象

SELECT OWNER,SEGMENT_NAME,SUM(bytes/1024/1024/1024 ) sum from Dba_Segments group by owner,segment_name having sum(bytes/1024/1024/1024 )>2 order by 3 desc; 

3、统计Oracle数据库用户所有表的大小