Home » RDBMS Server » Server Administration » CBO - Initial Parameters
CBO - Initial Parameters [message #262231] Sat, 25 August 2007 09:09 Go to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I would like to parameter CBO values.
To start setting these parameters... what are the good initial values for:
*.OPTIMIZER_MODE ==>
*.OPTIMIZER_INDEX_COST_ADJ ==>
*.OPTIMIZER_INDEX_CACHING ==>

How can I interact between these parameter and execution plan?
Any tutorial?
Thank you,

mson77
Re: CBO - Initial Parameters [message #262239 is a reply to message #262231] Sat, 25 August 2007 10:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start with default values and change them if you have problems with your execution plans.

Have a look at this paper from J. Lewis: Why isn't Oracle using my index?

Regards
Michel
Re: CBO - Initial Parameters [message #262282 is a reply to message #262239] Sat, 25 August 2007 22:03 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello Michel,

Thank you very much for your information.
As this thread being read for many others... I would like to post another document I found using google:
http://www.trivadis.com/Images/CBOConfigurationRoadmap_EN_tcm17-14317.pdf
http://www.doag.de/pub/docs/regio/hamburg/2005/09/01-CBOConfigurationRoadmap.pdf
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533.pdf

Regards,

mson77

[Updated on: Sat, 25 August 2007 22:27]

Report message to a moderator

Previous Topic: Security patches for Oracle 9208.
Next Topic: SPFILE persistent across startups
Goto Forum:
  


Current Time: Sun Dec 11 06:33:36 CST 2016

Total time taken to generate the page: 0.07768 seconds