Is 10g can use 200 MB of memory for hash joins ?
Hi,
I have datawarehouse on 10gR2(10.2.0.4.0) with 3 instance RAC with 64 GB RAM on each
- workarea_size_policy = AUTO and
- pga_aggregate_target(7GB) and
- SGA = 32 Gb on each instance
I was reading on the internet and found that - "...on Oracle 10g, the hash join maximum is only to only 200 megabytes (5% of pga_aggregate_target )."( http://www.dba-oracle.com/tips_oracle_hash_joins.htm )
Now questions are :
- How much maximum memory can be used by hash join operation in my environment ?
- Do I have to configure any specific parameter( like hash_area_size ) , so that Oracle uses Hash join or uses hash join effectively ?
I have datawarehouse on 10gR2(10.2.0.4.0) with 3 instance RAC with 64 GB RAM on each
- workarea_size_policy = AUTO and
- pga_aggregate_target(7GB) and
- SGA = 32 Gb on each instance
I was reading on the internet and found that - "...on Oracle 10g, the hash join maximum is only to only 200 megabytes (5% of pga_aggregate_target )."( http://www.dba-oracle.com/tips_oracle_hash_joins.htm )
Now questions are :
- How much maximum memory can be used by hash join operation in my environment ?
- Do I have to configure any specific parameter( like hash_area_size ) , so that Oracle uses Hash join or uses hash join effectively ?
0