Home » RDBMS Server » Performance Tuning » Are system procedures using Rule hint in Oracle 10g? (10g)
Are system procedures using Rule hint in Oracle 10g? [message #342150] Thu, 21 August 2008 09:35 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Does any of the system in built procedures in oracle 10g uses Rule Hint? Does v$ queries still using rbo in 10g?



Regards,
Oli

[Updated on: Thu, 21 August 2008 09:57]

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342153 is a reply to message #342150] Thu, 21 August 2008 09:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

RULE hint is obsolete in 10g, so answer is NO.
Re: Are system procedures using Rule hint in Oracle 10g? [message #342154 is a reply to message #342153] Thu, 21 August 2008 10:03 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Mohammad Taj wrote on Thu, 21 August 2008 09:58
RULE hint is obsolete in 10g, so answer is NO.





To my knowledge RBO is still there in 10g and works as previous versions.

Just curious if v$ queries still using rbo in 10g.


Regards,
Oli
Re: Are system procedures using Rule hint in Oracle 10g? [message #342161 is a reply to message #342154] Thu, 21 August 2008 10:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Just curious if v$ queries still using rbo in 10g.

This is i want to tell you.

RULL (RBO) is obsolete in 10g but for backward compatibility we can use it for our application(SQL) statement. but Oracle Is not using RBO anymore.

From 10gr1 Doc.
CHOOSE
This parameter value has been desupported.

RULE
This parameter value has been desupported.

Re: Are system procedures using Rule hint in Oracle 10g? [message #342162 is a reply to message #342161] Thu, 21 August 2008 10:31 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Thanks for the reply.

I asked simply whether v$queries in 10g are using Rule hints or not.
Regards,
Oli
Re: Are system procedures using Rule hint in Oracle 10g? [message #342168 is a reply to message #342162] Thu, 21 August 2008 10:52 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

v$queries in 10g are using Rule hints or not.

NO.
Re: Are system procedures using Rule hint in Oracle 10g? [message #342171 is a reply to message #342162] Thu, 21 August 2008 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Olivia wrote on Thu, 21 August 2008 08:31
Thanks for the reply.

I asked simply whether v$queries in 10g are using Rule hints or not.
Regards,
Oli



Since you have NO control over whether they are used or not,
how will your behavior change when you have either a YES or a NO answer?

How do you or anyone benefit by knowing this answer?
Re: Are system procedures using Rule hint in Oracle 10g? [message #342186 is a reply to message #342150] Thu, 21 August 2008 11:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is yes, and then?

Regards
Michel
Re: Are system procedures using Rule hint in Oracle 10g? [message #342190 is a reply to message #342186] Thu, 21 August 2008 11:41 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Michel Cadot wrote on Thu, 21 August 2008 11:32
The answer is yes, and then?

Regards
Michel




Then I would ask why? Smile why it does not use other hints?
It could make optimized using other hints too.why??


Probably a wild thinking...






Regards,
Oli


[Updated on: Thu, 21 August 2008 11:43]

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342194 is a reply to message #342190] Thu, 21 August 2008 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Saying it uses rule hint in some view does not mean it does not use other hints in other views.
For instance, in V$ACTIVE_SESSION_HISTORY it uses "no_merge ordered use_nl" (which is actually not so far from "rule" but is safe for the future).

Regards
Michel
Re: Are system procedures using Rule hint in Oracle 10g? [message #342195 is a reply to message #342194] Thu, 21 August 2008 11:53 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
If rule hints are no more officially supported then why using RULE hint in 10g itself. Why it was not replaced?


Uses of Rule hint compels me to think that in 10g itself there is no alternative of Rule hint in some views. If something is not supported, then it should be replaced.


Regards,
Oli
Re: Are system procedures using Rule hint in Oracle 10g? [message #342198 is a reply to message #342195] Thu, 21 August 2008 12:05 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Olivia wrote on Thu, 21 August 2008 09:53
If rule hints are no more officially supported then why using RULE hint in 10g itself. Why it was not replaced?


Uses of Rule hint compels me to think that in 10g itself there is no alternative of Rule hint in some views. If something is not supported, then it should be replaced.


Regards,
Oli


Take your issue up with Oracle.
Nobody here can assist with your fixation on RULE hint in V10 & beyond.
Re: Are system procedures using Rule hint in Oracle 10g? [message #342210 is a reply to message #342195] Thu, 21 August 2008 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If rule hints are no more officially supported then why using RULE hint in 10g itself. Why it was not replaced?

Why Oracle should use the rules it prescibes? It can use its code as it wants, more it knows how and when it can use it.

It also uses many hints and code paths you don't even know and are not documented but this does not shock you just because you don't know it. The only difference is that you know this hint, just think rule hint as something that does not exist and your concern will fly away. Just think that rule hint does not mean using old RBO (something that may happen in the future) but just activating some code path in the optimizer.

Regards
Michel
Re: Are system procedures using Rule hint in Oracle 10g? [message #342343 is a reply to message #342210] Fri, 22 August 2008 01:35 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Quite a good reply indeed. Thanks


Regards,
Oli
Re: Are system procedures using Rule hint in Oracle 10g? [message #342570 is a reply to message #342150] Fri, 22 August 2008 17:30 Go to previous message
coleing
Messages: 213
Registered: February 2008
Senior Member
Yeah, what Oracle say and what they do are 2 different things.

In 10 g Oracle says "dont use LONG's anymore - upgrade to CLOBS", and all the dictionaory views are still full of LONGS.
Previous Topic: Performance Tunning issue 9i
Next Topic: need suggestions to optimize the query
Goto Forum:
  


Current Time: Sat Dec 03 15:52:13 CST 2016

Total time taken to generate the page: 0.12726 seconds