[oracle][recyclebin] Analisando e apagando a recyclebin

ORACLE RECYCLEBIN

Mostra os objetos da recyclebin


select * from recyclebin;


Retorna o tamanho total da RECYCLEBIN e uma relação de quantos objetos existem por schema

select r.owner,
 count(distinct r.original_name) orig_obj,
 count(distinct r.object_name) objects,
 sum(bytes)/1024 kb
  from dba_recyclebin r
   join dba_segments s
    on (r.owner = s.owner and r.object_name = s.segment_name)
group by r.owner;

Apaga a recyclebin


PURGE RECYCLEBIN;