RE: Help CBO ANOMALY!!! - BUG WITH HASH_AREA_SIZE? :)

Paula

> Problem:
>  
> I have a query that uses a number of hash joins.  It takes over a
> minute to run each time.  I modify my session and explicitly set
> hash_area_size to 3,500,000 it runs in 2 seconds.  When I look at
> the parameters for the session hash_area_size is set to:
>
> hash_area_size                integer 8192000

Eventually I miss something... but to me it seams just fine. If you decrease hash_area_size the CBO increases the cost of hash joins and therefore another execution plan, which in this case contains a nested loop, is chosen.

Regards,
Chris

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