Re: Db Query Tuning

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 20 Feb 2007 07:30:43 -0700
Message-Id: <20070220143008.0BC6D606ADE@turing.freelists.org>

At 12:39 AM 2/20/2007, Syed Jaffar Hussain wrote:
>Sanjay,
>
>I do agree with Wolfgang Breitling.
>
>However, if you are on 10g, I would suggest to enable event 10132 in
>place of 10053.
>
><http://jonathanlewis.wordpress.com/2006/11/27/event-10132/>http://jonathanlewis.wordpress.com/2006/11/27/event-10132/

However, that will only give you the comparison of the optimizer parameters, not the comparison of whether and where the base table cardinality estimates differ as well as other differences in the way the CBO assembles the access plans.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

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

Received on Tue Feb 20 2007 - 08:30:43 CST