常用sql语句–查看占用空间大的表

语句中的{tablespace_name}根据实际情况修改为表空间名称

select t.owner, t.segment_name,sum(t.bytes)/1024/1024/1024 aa from dba_segments t
where t.tablespace_name='{tablespace_name}' /*and t.partition_name is not null*/
group by t.owner,t.segment_name 
order by aa desc;