My Oracle Support Banner

dia0 High Memory Usage (Doc ID 1376981.1)

Last updated on MARCH 19, 2018

Applies to:

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

Symptoms to 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.

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.pname,, 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 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


To view full details, 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 a vibrant support community of peers and Oracle experts.