PURGE DBA_RECYCLEBIN taking a long time

Just check DBA_SEGMENTS for SEGMENT_NAME like ‘BIN%’, and it should be dropping in number…

SQL> select count(*) from dba_segments where segment_name like 'BIN%';

  COUNT(*)
----------
      2307

SQL> select count(*) from dba_segments where segment_name like 'BIN%';

  COUNT(*)
----------
      2297

SQL> select count(*) from dba_segments where segment_name like 'BIN%';

  COUNT(*)
----------
      2281

SQL> select count(*) from dba_segments where segment_name like 'BIN%';

  COUNT(*)
----------
      2275

SQL> select count(*) from dba_segments where segment_name like 'BIN%';

  COUNT(*)
----------
      2207

SQL>