Insufficient swap memory can cause the ORA-04030: out of process memory?
Checked PGA hit percentage is 100%
Shared the alert log message below.
Errors in file /dborafiles/admin/diag/rdbms/<dbname>/<instance_name>/trace/<instance_name>_ppa7_9545.trc (incident=4587672) (PDBNAME=CDB$ROOT):
ORA-04030: out of process memory when trying to allocate 225416896 bytes (kxs-heap-w,krvxlogact)
Incident details in: /dborafiles/admin/diag/rdbms/<dbname>/<instance_name>/incident/incdir_4587672/<instance_name>_ppa7_9545_i4587672.trc
Current system swap is below 1%
Memory (Avail / Total) = 42067.48M / 201339.79M
Swap (Avail / Total) = 32679.75M / 32764.00M
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details. Trace Log
DDE encountered the following error:
ORA-10388: parallel query server interrupt (failure)
ORA-04030: out of process memory when trying to allocate 220281016 bytes (kxs-heap-w,krvxlogact)
WARNING: out of private memory [2]
Seems like your database is trying to allocate 225416896 bytes of memory but its not available on SGA. Try to add memory to SGA and decrease PGA. Also check for queries that taking lot of memory and tune them.