OraFAQ Forum: Server Administration » CBO

Home » RDBMS Server » Server Administration » CBO - Initial Parameters

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

CBO - Initial Parameters [message #262231]

Sat, 25 August 2007 09:09

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

Report message to a moderator

Re: CBO - Initial Parameters [message #262239 is a reply to message #262231]

Sat, 25 August 2007 10:00

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: CBO - Initial Parameters [message #262282 is a reply to message #262239]

Sat, 25 August 2007 22:03

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:35:29 CDT 2024