Re: Large Parse times

From: Winnie Liu <poohland_at_hotmail.com>
Date: Thu, 9 Jul 1998 19:34:57 -0700
Message-ID: <6o3ucj$48v@sjx-ixn10.ix.netcom.com>

Try to change the parameters ALWAYS_ANTI_JOIN to hash. Then Oracle will choose to use hash join whenever there is a NOT IN parameters. Try the Oracle Doc for more info for this.

Winnie Liu
poohland_at_hotmail.com

Asko Tiidumaa wrote in message <6o2hae$3qu$2_at_kadri.ut.ee>...
>> Increase the size of the SHARED_POOL , pin any frequently used packages,
>> sounds like a problem with fragmentation or insufficiently size SGA.
>
>I had the same-alike problem. I created statistics for all tables involved
>in query, and the problem disappeared. But then the optimizer started to
>use NESTED_LOOPS instead of hash joins.
>
>
>Asko Tiidumaa
>
Received on Thu Jul 09 1998 - 21:34:57 CDT