When running URT we see the following messages ORA-06580: Hash Join ran out of memory while keeping large rows in memory
ORA-06580: Hash Join ran out of memory while keeping large rows in memory
Oracle 12c
setting PGA memory management to Manual mode will lead to ORA-06580: Hash Join ran out of memory while keeping large rows in memory.
In such cases following parameters WORKAREA_SIZE_POLICY will be manual and PGA_AGGREGATE_TARGET will be zero.
Above oracle 9i avoid manual PGA management and use automatic mode.
Steps:
Edit spfile and set the parameters by logging as SYSDBA as follows:
NOTE: PGA_AGGREGATE_TARGET=300M - or any other bigger value