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.