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
Any version of Oracle
Setting PGA memory management to Manual mode will lead to "ORA-06580: Hash Join ran out of memory while keeping large rows in memory."
Additionally, the parameter WORKAREA_SIZE_POLICY will be set to "manual" and PGA_AGGREGATE_TARGET=0.
Above Oracle 9i, avoid manual PGA management and use Automatic mode.
Steps:
Set the parameters by logging in as SYSDBA and editing as follows:
NOTE: PGA_AGGREGATE_TARGET=300M - or any other bigger value as determined by DBA
Setting scope to BOTH will edit the spfile as well as the current instance.