查询dba_jobs_running慢的bug
前段时间在一台小型机上查询dba_jobs_running看正在执行的作业时俱慢，只好用dba_jobs代替,原来是个bug,oracle9.2版本，aix系统。
Subject: Query on DBA_JOBS_RUNNING is Slow in Oracle 9.2
Doc ID: Note:240058.1 Type: PROBLEM
Last Revision Date: 05-MAY-2004 Status: PUBLISHED
fact: Oracle Server - Enterprise Edition 9.2
symptom: Query on DBA_JOBS_RUNNING is slow
cause: This problem is described in the Bug 2624130 - QUERY AGAINST
DBA_JOBS_RUNNING IS USING CBO EVEN WHEN NO STATISITICS
fix:
Workaround:
Use /*+ rule */ hint.
I.e: select /*+ rule */ * from dba_jobs_running;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/112417/viewspace-896224/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
