RE: rm RULE based optimizer != GOOD IDEA
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <CMarquez@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 09:39:39 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Friday, April 22, 2005 9:27 AM
To: oracle-l@xxxxxxxxxxxxx
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"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
