查詢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;

[@more@]