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