OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Cost of a query (Oracle 10.2.0.3)

Wed, 28 July 2010 10:11

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

Wed, 28 July 2010 10:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Wed, 28 July 2010 10:22

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

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

Wed, 28 July 2010 10:30

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]

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

Goto Forum:

]

Current Time: Sat May 04 02:58:32 CDT 2024