oracle清理oracle空间

 

 

--统计各个用户占用的空间
select owner, round(sum(bytes)/1024/1024,0) "used MB" from dba_segments group by owner order by 2;

--统计某个用户占用各个表空间的情况
select round(sum(bytes)/1024/1024,0) "used MB", TABLESPACE_NAME from dba_segments where owner='用户名' group by TABLESPACE_NAME;

--统计某个用户下,各个表点用的空间情况
select round(sum(bytes)/1024/1024,0) "used MB", t.segment_name from dba_segments  t where owner='用户名' group by segment_name order by 1 desc;

-- 关闭oracle闪回功能
alter database flashback off;

-- 删除某一个回收站的表, 注意要切换到这个表的用户下操作.
PURGE TABLE "BINjR8PK5HhrrgMK8KmgQ9nw==";

-- 删除当前用户下,所有的bin回收站表
PURGE RECYCLEBIN;

--修改为默认关闭 回收站功能， 需要重启数据库: alter system set recyclebin=off DEFERRED;