Home » Other » General » How to find (oracle 8i and 11g)
How to find [message #526536] Tue, 11 October 2011 08:57 Go to next message
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.
Re: How to find [message #526542 is a reply to message #526536] Tue, 11 October 2011 09:14 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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.
Re: How to find [message #526544 is a reply to message #526542] Tue, 11 October 2011 09:20 Go to previous messageGo to next message
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
Re: How to find [message #526546 is a reply to message #526542] Tue, 11 October 2011 09:24 Go to previous messageGo to next message
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
Re: How to find [message #526548 is a reply to message #526546] Tue, 11 October 2011 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> show parameter optimizer_mode
Re: How to find [message #526561 is a reply to message #526546] Tue, 11 October 2011 10:05 Go to previous message
Michel Cadot
Messages: 67951
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
Previous Topic: my Oracle Support
Next Topic: unix - hp-ux iso image
Goto Forum:
  


Current Time: Mon Sep 27 06:29:42 CDT 2021