Datatombraider's Blog

2017/05/09

Memory leak in asmb in version 12.1.0.2

Filed under: Oracle — datatombraider @ 21:51

After upgrading our cluster from GI 11.2.0.4 to GI 12.1.0.2 we had problems due to insufficent memory. Every node has 144 GB memory, 80 GB for SGA, remaining memory for applications. We traced the memory consumption of the applications and noticed two processes growing indefinetely:

USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 11879 0.1 19.2 33592852 28646580 ? Ss Apr04 47:46 oracle+ASM4_asmb_+asm4 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 11875 0.0 19.5 34051676 29101320 ? Ss Apr04 34:15 asm_asmb_+ASM4

These 2 processes consumed 38% of available memory and kept growing.

We hit the bug described in “SQLPlus 12c Memory usage Grows (Leaks) While Running Long Query (Doc ID 1919000.1)”. The title is misleading, but the solutions given in the Document fixed the issue, asmb’s memory consumption returned to normal and stays at that level.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.