QMON Slave Process (Q00X) Leaks Memory in 10.2.0.5 or Generates : ORA-4030 (Doc ID 1379309.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

Having applied the 10.2.0.5 Oracle Server patchset, the qmon slave process : Q00X is
observed either to show increasing memory usage as is detailed in the v$process view or will fail with the error ara-4030.

This has the same profile as : 6009358 which is supposedly fixed in 10.2.0.5.

Note : in order to diagnose / confirm this issue , it is necessary to set the following event prior
to obtaining a heap dump of the process; furthermore the instance needs to be stopped and restarted for the
event to take affect :
- 10235 / level 65536

All the above event does is ensure that the mnemonic linked with a permanent memory chunk allocation
is output in the trace file produced. This is not done if the event is not set.

A heapdump of the qmon slave leaking memory can then be generated using :

sqlplus "/ as sysdba"
oradebug setospid X  (X is the os process id of the qmon slave)
oradebug unlimit
oradebug dump heapdump level 268435485

The above shows significant memory allocations connected with :

"kprbalo temp me" and "CPM trailer" chunk allocations

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