Home » RDBMS Server » Performance Tuning » Cost of a query (Oracle 10.2.0.3)
Cost of a query [message #468012] Wed, 28 July 2010 10:11 Go to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Is there any documentation/link where I can find how cost is being calculated by the optimizer?


Regards
Ved

Report message to a moderator

Re: Cost of a query [message #468013 is a reply to message #468012] Wed, 28 July 2010 10:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Get the book
http://www.amazon.com/Cost-Based-Oracle-Fundamentals-Experts-Voice/dp/1590596366

Report message to a moderator

Re: Cost of a query [message #468014 is a reply to message #468012] Wed, 28 July 2010 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, it is named trace 10053, there are a couple of notes on it and on CBO in Metalink.

Regards
Michel

Report message to a moderator

Re: Cost of a query [message #468015 is a reply to message #468014] Wed, 28 July 2010 10:30 Go to previous message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Thanks to you both for providing the information


Regards
Ved

[Updated on: Wed, 28 July 2010 10:45]

Report message to a moderator

Previous Topic: Tuning Schemas
Next Topic: Which application (software, utility) do I choose for report?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 10:14:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.