QMON Slave Process (Q00X) Leaks Memory in 10.2.0.5 or Generates : ORA-4030
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.
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 dump heapdump level 268435485
The above shows significant memory allocations connected with :
"kprbalo temp me" and "CPM trailer" chunk allocations
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