dba_jobs_running faster as rule based?

From: RR <rickraster_at_hotmail.com>
Date: 19 Aug 2003 10:05:18 -0700
Message-ID: <97b4acf3.0308190905.3d9e1535@posting.google.com>

9r2, linux

Consider the following:

SQL>select * from dba_jobs_running;

SID Jb# F LAST_DATE LAST_SEC THIS_DATE THIS_SEC INSTANCE
---------- ---- --- --------- -------- --------- -------- ----------

23 402 0 19-AUG-03 09:46:55 19-AUG-03 09:54:39 0 1 row selected.
Elapsed: 00:00:06.00

SQL>select /*+ rule */ * from dba_jobs_running;

SID Jb# F LAST_DATE LAST_SEC THIS_DATE THIS_SEC INSTANCE
---------- ---- --- --------- -------- --------- -------- ----------

23 402 0 19-AUG-03 09:46:55 19-AUG-03 09:54:39 0 1 row selected.
Elapsed: 00:00:00.00

Can anyone provide any insight into why the rule hint is so much faster here? I assumed based on all that I've heard, that v9 was basically rule-based free, yet here the hint provides a huge performance boost.

Do I need to analyze the sys schema?

Thanks all!

Rick Received on Tue Aug 19 2003 - 12:05:18 CDT