Home » RDBMS Server » Performance Tuning » Use of RBO in 10g
Use of RBO in 10g [message #286747] Mon, 10 December 2007 01:19 Go to next message
kingo
Messages: 13
Registered: October 2007
Junior Member
Is it possible to use RBO in oracle 10g?
Please help me know.

Thanks,
Kingo
Re: Use of RBO in 10g [message #286749 is a reply to message #286747] Mon, 10 December 2007 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Use of RBO in 10g [message #286751 is a reply to message #286749] Mon, 10 December 2007 01:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
HOW?
Re: Use of RBO in 10g [message #286761 is a reply to message #286751] Mon, 10 December 2007 01:38 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Same as for previous versions, it's just that Oracle no longer recommends its usage.

If you have trouble with the RBO in 10g, Oracle probably won't help you, and they certainly won't patch any bugs. They will just instruct you to start using CBO.
Re: Use of RBO in 10g [message #286800 is a reply to message #286761] Mon, 10 December 2007 02:48 Go to previous messageGo to next message
kingo
Messages: 13
Registered: October 2007
Junior Member
How can we use it?

Re: Use of RBO in 10g [message #286801 is a reply to message #286800] Mon, 10 December 2007 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
First and most important is "why do you want to use it?".

Regards
Michel
Re: Use of RBO in 10g [message #286813 is a reply to message #286801] Mon, 10 December 2007 03:05 Go to previous messageGo to next message
kingo
Messages: 13
Registered: October 2007
Junior Member
I have done some performance improvement in certain queries using RBO and the client are doubtful whether when they migrate to 10g it wont be supported so I want know whether RBO is supported and If possible I want to use them.
Re: Use of RBO in 10g [message #286819 is a reply to message #286813] Mon, 10 December 2007 03:11 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Is it supported? No.
Can you use it? Yes.
Is it adviceable to use it? No.
Can you have some performances issues? Yes.
This is the reason of tests.

Regards
Michel
Previous Topic: Need to tune SQL involving Join
Next Topic: Poorly performing SQL query
Goto Forum:
  


Current Time: Tue Nov 26 21:45:21 CST 2024