Oracle DB 12.2.0
GRID 12c
Hello Team,
I noticed my scripts were failing because DB was down.
I checked alert log and noticed
Errors in file /u01/app/oracle/diag/rdbms/dware1/DWARE1/trace/DWARE1_mmon_5054.trc (incident=573776):
ORA-00445: background process "m001" did not start after 120 seconds
PGA_AGGREGATE_LIMIT has been exceeded but some processes using the most PGA
memory are not eligible to receive ORA-4036 interrupts. Further occurrences
of this condition will be written to the trace file of the CKPT process.
How do I calculate the PGA and SGA if my RAM is 32 GB?
Also, how do I set processes and sessions?
Thanks
Joe