Re: NL & Hash Outer Join question
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Thu, 25 Jan 2007 14:08:02 -0700
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
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
