OraFAQ Forum: Performance Tuning » Are system procedures using Rule hint in Oracle 10g?

Home » RDBMS Server » Performance Tuning » Are system procedures using Rule hint in Oracle 10g? (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Are system procedures using Rule hint in Oracle 10g? [message #342150]

Thu, 21 August 2008 09:35

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

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

RULE hint is obsolete in 10g, so answer is NO.

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342154 is a reply to message #342153]

Thu, 21 August 2008 10:03

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

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342161 is a reply to message #342154]

Thu, 21 August 2008 10:28

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.

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342162 is a reply to message #342161]

Thu, 21 August 2008 10:31

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

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342168 is a reply to message #342162]

Thu, 21 August 2008 10:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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

NO.

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342171 is a reply to message #342162]

Thu, 21 August 2008 11:02

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342186 is a reply to message #342150]

Thu, 21 August 2008 11:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The answer is yes, and then?

Regards
Michel

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342190 is a reply to message #342186]

Thu, 21 August 2008 11:41

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342195 is a reply to message #342194]

Thu, 21 August 2008 11:53

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

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342198 is a reply to message #342195]

Thu, 21 August 2008 12:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Olivia wrote on Thu, 21 August 2008 09:53

Take your issue up with Oracle.
Nobody here can assist with your fixation on RULE hint in V10 & beyond.

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342210 is a reply to message #342195]

Thu, 21 August 2008 12:38

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342343 is a reply to message #342210]

Fri, 22 August 2008 01:35

Olivia
Messages: 519
Registered: June 2008

Senior Member

Quite a good reply indeed. Thanks

Regards,
Oli

Report message to a moderator

Re: Are system procedures using Rule hint in Oracle 10g? [message #342570 is a reply to message #342150]

Fri, 22 August 2008 17:30

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.

Report message to a moderator

Previous Topic:	Performance Tunning issue 9i
Next Topic:	need suggestions to optimize the query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:03:44 CST 2024