DIA0 eat too many memory
Hello,
Anyone have idea?
Thanks
My Oracle database environment:
- Oracle database 12c standard edition (RAC)
- 3 x nodes
- OS: Solaris 11
---------------------------------------------------------------------------------------------------
I found the 'DIA0" process eating too memory process:
load averages: 1.79, 1.98, 1.99; up 98+22:35:00 10:14:04
659 processes: 654 sleeping, 3 running, 2 on cpu
CPU states: 13.3% idle, 55.7% user, 31.0% kernel, 0.0% iowait, 0.0% swap
Kernel: 20750 ctxsw, 12648 trap, 13979 intr, 25339 syscall, 23 fork, 4393 flt
Memory: 24G phys mem, 275M free mem, 16G total swap, 13G free swap
PID USERNAME NLWP PRI NICE SIZE RES STATE TIME CPU COMMAND
503 oracle 1 29 0 13G 9218M sleep 128.2H 19.03% oracle
2775 grid 1 60 0 4420M 2981M sleep 0:01 5.69% oracle
---------------------------------------------------------------------------------------------------
Process detail:
SPID USERNAME PROGRAM TRACEFILE B PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM