OraFAQ Forum: General » How to find

Home » Other » General » How to find (oracle 8i and 11g)

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

How to find [message #526536]

Tue, 11 October 2011 08:57

9390512774
Messages: 103
Registered: January 2011
Location: hyd

Senior Member

Hi Experts,

When I am executing a query,

1.)how can I know, Whether its using RBO or CBO?

2.)If its using RBO then how to change it to use CBO?

3)Is RBO yields best performance or CBO yields Best performance?

Thanks in advance.

Report message to a moderator

Re: How to find [message #526542 is a reply to message #526536]

Tue, 11 October 2011 09:14

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use code tags for code. Not questions.

1) If it's 11g it'll be CBO. For 8i it depends on the optimiser mode parameter. Run an explain plan for the query. If it gives a cost figure you're using the CBO.
2) Change the optimiser mode parameter.
3) CBO - which is why oracle have got rid of the RBO.

Report message to a moderator

Re: How to find [message #526544 is a reply to message #526542]

Tue, 11 October 2011 09:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is RBO yields best performance or CBO yields Best performance?
It depends.
Some SELECT were written to take advantage of RBO & when moved to DB using CBO perform badly

Report message to a moderator

Re: How to find [message #526546 is a reply to message #526542]

Tue, 11 October 2011 09:24

9390512774
Messages: 103
Registered: January 2011
Location: hyd

Senior Member

Quote:

1) If it's 11g it'll be CBO. For 8i it depends on the optimiser mode parameter. Run an explain plan for the query. If it gives a cost figure you're using the CBO.

How to change the optimiser mode parameter.
Where can we find this parameter

Report message to a moderator

Re: How to find [message #526548 is a reply to message #526546]

Tue, 11 October 2011 09:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> show parameter optimizer_mode

Report message to a moderator

Re: How to find [message #526561 is a reply to message #526546]

Tue, 11 October 2011 10:05

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

9390512774 wrote on Tue, 11 October 2011 16:24

Quote:

1) If it's 11g it'll be CBO. For 8i it depends on the optimiser mode parameter. Run an explain plan for the query. If it gives a cost figure you're using the CBO.

How to change the optimiser mode parameter.
Where can we find this parameter

All parameters are described in Database Reference.
Bookmark it so you will have no more question on parameters.

Regards
Michel

Report message to a moderator

Previous Topic:	my Oracle Support
Next Topic:	unix - hp-ux iso image

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 21:57:19 CDT 2023