dba_jobs_running查詢速度很慢

網路找的答案是Oracle 9i的Bug,可以用hint來試著解決:
select /*+ rule */ * from dba_jobs_running;

<Bug:2624130> 
QUERY AGAINST DBA_JOBS_RUNNING IS USING CBO EVEN WHEN NO STATISITICS.

Oracle DB的listener.log清理