Re: dba_jobs_running faster as rule based?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 19 Aug 2003 20:48:35 +0200
Message-ID: <h2s4kv0g1gkaeo9uvr5jeo4sp9unj2tfuk@4ax.com>

On 19 Aug 2003 10:05:18 -0700, rickraster_at_hotmail.com (RR) wrote:

>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.

Actually you didn't proof at all the rule hint is faster. After the first select the data is in the buffer cache, so you are simply getting it from the buffer cache. One would need to see the actually amount of Logical I/O (which will be constant, depending on execution plan) to draw any conclusions.
I don't think 9i is rule free, and if you analyze the SYS schema (which is NOT recommended), the SYS schema won't be running on the RBO anymore, which it does now.
In short, don't know what you trying to accomplish, and it looks like you see a fata morgana.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 19 2003 - 13:48:35 CDT