Hello Experts,
In one exadata box we are getting the below error:-
EXADATA machine:- ORACLE SERVER X6-2L
DB Version: 12.1.0.2
EM: 13.2.0
In both(node1 and node2) the instance:-
sga_max_size:24G
sga_target: 24G
pga_aggregate_limit:16G
pga_aggregate_target:12G
An EM alert is keep on occuring which shows as below in the alert log file:-
ORA-04030: out of process memory when trying to allocate 201847728 bytes (kxs-heap-w,krvxlogact)
ORA-04030: out of process memory when trying to allocate bytes (,)
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/fncusap/FNCUSAP2/trace/FNCUSAP2_ppa7_182867.trc
Trace file shows as below:-
WARNING: out of private memory [2]
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 109358)
ORA-04030: out of process memory when trying to allocate 643607576 bytes (kxs-heap-w,krvxlogact)
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 109359)
ORA-04030: out of process memory when trying to allocate 643607576 bytes (kxs-heap-w,krvxlogact)
DDE: Problem Key 'ORA 4030' was flood controlled (0x6) (incident: 109361)
ORA-04030: out of process memory when trying to allocate bytes (,)
WARNING: out of private memory [2]
*** 2018-07-18 05:37:22.138
*** SESSION ID:(130.53737) 2018-07-18 05:37:22.138
*** SERVICE NAME:(SYS$USERS) 2018-07-18 05:37:22.138
*** MODULE NAME:(emagent_SQL_rac_database) 2018-07-18 05:37:22.138
*** ACTION NAME:(capture_message) 2018-07-18 05:37:22.138
Regards,