RE: rm RULE based optimizer != GOOD IDEA

My prediction is that RULE hint will really go away as soon as apps no longer uses it anywhere. I have heard the same thing about its use.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Friday, April 22, 2005 9:27 AM
To: oracle-l_at_freelists.org
Subject: RE: rm RULE based optimizer !=3D GOOD IDEA

I have not supported Oracle Apps, but from what I understand it is loaded with hints and I believe some of the using "RULE hint. Seems a little "Do as I say not as I do" from Oracle Corp....eh?

I agree about the spending all day on with stats and explain plans. I have a script to look for blocking locks using v$ views...it ran ok, but a DBA friend made if faster in about 5 minutes by adding a RULE hint.
Maybe I should be going after the base Oracle tables, but I don't have all day.

Finally about execution plans and speed changing of sql using the RBO. If I'm not mistaken many environment changes can effect CBO too!?

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

--
http://www.freelists.org/webpage/oracle-l