oracle回收站过大导致查询表空间语句反应慢

Queries on DBA_FREE_SPACE are Slow (文档 ID 271169.1)

文档中说：

dba_free_space 是个视图，基表中有：sys.recyclebin$

当回收站中内容过大，会拖慢对该视图的查询。

解决方案：
业务用户清理回收站：Purge the recyclebin.

For example:

SQL> purge recyclebin;

Recyclebin purged.

Or, as SYSDBA for system wide purging.  --或sysdba用户清理全局回收站

SQL> purge dba_recyclebin;

Recyclebin purged.