Re: Hash Joins

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 20 Jan 2004 18:39:35 +0100
Message-ID: <vrpq00p96u5djd2idieq142f5cmi6s3ale@4ax.com>

On Tue, 20 Jan 2004 11:47:04 GMT, no-spam_at_no-spam.com wrote:

>Hi
>
>Our oracle server uses hash joins for some queries I have allocated
>hash_size area in the init.ora file.
>
>My question is if the has joined table does not fit in to the memory
>specified does it try and use the disk ? if so how to do I find out if
>my hash memeory alloaction is enough.
>
>This may be a completeluy dum question as I am new to Oracle
>
>Thanks

If the hash join doesn't fit in memory the temporary tablespace will be used.
The second question is very difficult to answer as you don't mention -as many many many others- which version you are using and the answer is version specific.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jan 20 2004 - 11:39:35 CST