Re: hash_area_size

On Thu, 28 May 1998 07:35:21 GMT, andreas.prusch_at_sintec.de <andreas.prusch_at_sintec.de> wrote:
>We want to know the handling of the hash_area_size. We know that Oracle
>allocates hash_area_size on a per process basis and that the size is default
>2 * sort_area_size. So will we have to reserve the memory for hash area for
>all processes in addition to sort area. Perhaps, Oracle will use sort area
>for hashing? Or is the memory for hash area is deallocate after hashing? And
>on MTS configuration the hash area is allocated in the shared pool?
>By the way, hash joins will speed up joins enormous.

Example 5, page 19-53 of the Oracle8 Server Tuning Manual seems to show the hash area is in addition to the sort area. The manual implies that MTS allocates the area from the shared pool, perhaps that could be determined by manipulating hash_area_size and watching v$shared_pool_reserved.

>
>Thanks you,
>
>Andreas Prusch
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.