Unable to allocate memory for new incident error in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/instance_name_m72034.trc:ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT I had a same problem and solved it by doing the following. See what the current pga_aggregate_limit is using this (in case you want to revert your changes): show parameter pga_aggregate_limit; alter system set pga_aggregate_limit = […]

Hi Folks,I recently saw wait events on the single instance database, the root cause of the problem was caused by the undo event “Wait for a undo record”. There are cases where parallel process recovery is not as fast as serial process recovery, because the PQ secondary can interfere with each other’s operation by competing […]