HASH_AREA_SIZE question

From: <kal121_at_yahoo.com>
Date: Thu, 10 Jun 1999 13:21:42 GMT
Message-ID: <7joe4s$hne$1@nnrp1.deja.com>

Hello,

I have a question about the parameter HASH_AREA_SIZE. I have several queries running in parallel that use a hash join. From what I've read, to use a hash join, additional memory is required as given by hash_area_size. My question is, how does the hash_area_size get allocated?

If I'm running 16 server processes, will it use up 16*hash_area_size in memory? This is what the Oracle documentation seems to suggest.

Is there a dynamic view where I can see this information?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 10 1999 - 08:21:42 CDT