Re: NL & Hash Outer Join question

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 25 Jan 2007 14:08:02 -0700
Message-Id: <20070125210723.F2F555B6005@turing.freelists.org>

Changes to the optimizer in releases 9.2.0.5, 9.2.0.6, 9.2.0.7 and 9.2.0.8 Just one release step can be enough. You've got 4 ! The CBO is hardly the same animal anymore.

At 01:59 PM 1/25/2007, rjamya wrote:
>What might cause a query using NL (in 9204) use Hash Outer Join (in
>9208) when all optimizer and memory parameter being same. I checked
>optimizer parameter values using 10053 trace.
>
>The tables involved are analyzed identical, contain identical data
>(9208 was cloned from 9204), they run on identical servers and only
>one person logs in and runs the test. Memory sizes etc are all identical.

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 Thu Jan 25 2007 - 15:08:02 CST