Re: Hash Joins

From: <no-apm_at_sapm.com>
Date: Wed, 21 Jan 2004 08:15:12 GMT
Message-ID: <400e3487.168560276@news.demon.co.uk>

On Tue, 20 Jan 2004 18:39:35 +0100, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>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.

Sorry, silly msitake.. We use oracle 8.1.7.4 running on Sparc Solaris 8. I would be extremely gratefull if you could point me in the direction as to how to find out if my hash area size is big enough.
>
>
>--
>Sybrand Bakker, Senior Oracle DBA
Received on Wed Jan 21 2004 - 02:15:12 CST