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>