<SPAN
class=437103023-29032001>Chuck, The closest I could come to a definate
answer on this one was in doc 58906.996<SPAN
class=921593023-29032001> where the Tech skirted the issue you asked
about.
<SPAN
class=437103023-29032001><SPAN
class=921593023-29032001>
<SPAN
class=437103023-29032001><SPAN
class=921593023-29032001>Quote
<SPAN
class=437103023-29032001><SPAN
class=921593023-29032001>
<SPAN
class=437103023-29032001>metalink
user >> "<FONT
color=#0000ff><SPAN
class=921593023-29032001>5. Does every client connection/session get
hash_area_size allocated or only those that execute a hash
join. tech >> I
believe that hash_area_size is allocated for a process that executes a hash
join. "
<SPAN
class=437103023-29032001><SPAN
class=921593023-29032001>
<SPAN
class=437103023-29032001>Great, but does it stay
allocated after?
<SPAN
class=437103023-29032001><SPAN
class=921593023-29032001>
From
playing around with it, I set my hash area size up to 16000000 and no memory was
allocated until I executed a query that hash joined. Once it was
allocated it wasn't released until the session ended. Also, I believe the
memory is not shared. (When I had 4 user processes executing the queries my
machine was down 64MB)
<SPAN
class=921593023-29032001>
<FONT
size=3> tech >> The memory for
hash_area_size is allocated from the User Global Area (UGA) of a user process.
For dedicated server connection, this is part of process memory (PGA). For
multi-threaded server, the UGA is allocated from either the Shared Pool or the
Large Pool, if the Large Pool is configured (recommended).
<SPAN
class=921593023-29032001>
<SPAN
class=921593023-29032001>Regards,
<SPAN
class=921593023-29032001>
Scott
Crabtree
<SPAN
class=437103023-29032001> -----Original Message-----From:
Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com]Sent: Thursday, March
29, 2001 4:01 PMTo: Multiple recipients of list
ORACLE-LSubject: hash_area_size
Is the hash area memory released back to the o/s when the
hash join operation is finished or does it remain allocated as long as the
session is still connected?
Received on Thu Mar 29 2001 - 17:41:19 CST
