Re: Poorly performing query and 10053 trace

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: 2006-01-13 10:31:52
Message-id: 1137144712l.4235l.1l@medo.noip.com

On 01/13/2006 01:14:52 AM, Niall Litchfield wrote:
> It is certainly an opportunity to order Jonathan Lewis' latest book Cost
> Based Oracle Fundamentals, chapter 14 of which walks through an example
> 10053 trace file (albeit from 10g), and which is the most complete
> documentation of this trace of which I am aware. There is also a fairly
> recent case study on metalink for this trace
> https://metalink.oracle.com/metalink/plsql/docs/CS_10053.htm will take you
> there.

Not wanting to diminish Jonathan's exquisite book, there is also an excellent article by Mr. Wolfgang Breitling, on http://www.centrexcc.com. The description is excellent and immediately usable. In the spirit of recent Christmas, I must say that Jonathan, Wolfgang and Chris Antognini are the three wise men of CBO.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 13 2006 - 10:31:52 CST