dia0 High Memory Usage (Doc ID 1376981.1)

Last updated on NOVEMBER 08, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms


11.1.0.7 to 11.2.0.3 ASM dia0 background process high memory consumption, over time it can exhaust physical memory and swap space resulting in node eviction or other stability issue.


PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+ COMMAND
7242 grid    18   0  28g 153m  19m S 83.2  0.7   6:21.22 oracle

ps -ef| grep 7242
grid      7242     1  0 Nov1 ?        00:00:06 asm_dia0_+ASM1

 

column name format a25
column pname format a12
column "MegaBytes" format a10
set numwidth 6

select ss.sid, p.pid, p.pname, sn.name, round(ss.value/(1024 *1024))||'Mb' "MegaBytes"
from v$sesstat ss, v$statname sn, v$session s, v$process p
where s.paddr = p.addr
and   sn.statistic# = ss.statistic#
and   s.sid = ss.sid
and   sn.name in ('session pga memory' , 'session pga memory max')
and   p.pname='DIA0'
order by ss.value
/


60      8 DIA0         session pga memory        58Mb
60      8 DIA0         session pga memory max    58Mb

After one day:

60      8 DIA0         session pga memory max    898Mb
60      8 DIA0         session pga memory        898Mb       ====>> growth is about 840MB per day in this example




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms