查看users表空间使用率高的原因

查看哪些占用比较多的段

select * from (select owner,segment_name,segment_type,sum(bytes)/1024/1024/1024 GB  
	from dba_segments 
	where tablespace_name='USERS'
	group by owner,segment_name,segment_type order by 4 desc ) 
where rownum <10;

删除表

alter session set current_schema=test;

删除用户