TO CHECK RECYCLEBINN SPACE

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;