Re: NL & Hash Outer Join question

Hmmm .... we don't use system stats, simply because we don't. As for 10053 trace, this specific query occures in middle of a process. This process assigns chunks of data to upto 10 slaves, grabs data returned by them, analyzes that and spits out final output.

So, I could only trace the whole process for 10053 trace. Now, I must admit that my latin is far better than the cryptic language of 10053 trace. So, it is my plan to print it out, and scan through it over the weekend.

thanks for the input.
rjamya

On 1/25/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Do both instances have (the same) system stats? What differences do you
> see in the 10053 trace?
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *rjamya
>
>
> What might cause a query using NL (in 9204) use Hash Outer Join (in 9208)
> when all optimizer and memory parameter being same.
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

-- 
----------------------------------------------
Got RAC?

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