MMON SLAVE Process Consuming More PGA Memory in 19c
(Doc ID 2721971.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- 19.7.0.0.0 MMON slave process is consuming more PGA memory than it did in 12.1.0.2 or 12.2 versions of the database:
TOP MODULE SCHEMANAME PGA_MB MAX_MB TYPE_PROGRAM
SID_SERIAL_SPID_PID LOGIN_TIME
---------- --------------- ----------- ---------- ----------
------------------------------------------ -------------------------
-------------------------
1 MMON_SLAVE SYS 304.53 350.54086 BACKGROUND /
oracle (M000) 463,1,25285,34 28-Apr-20 21:13:44
2 MMON_SLAVE SYS 299.4 335.47836 BACKGROUND /
(M001) 509,1,25287,35 28-Apr-20 21:13:44
3 MMON_SLAVE SYS 284.21 327.72836 BACKGROUND /
(M003) 332,1,21092,79 28-Apr-20 21:26:03
4 MMON_SLAVE SYS 132.4 179.35336 BACKGROUND /
(M005) 424,4860,9489,81 13-May-20 01:16:05
5 MMON_SLAVE SYS 113.54 153.932126 BACKGROUND /
(M004) 378,4558,23692,80 11-May-20 05:16:11 - From PGA heap dump:
Total_size #Chunks Chunk_size, From_heap, Chunk_type,
Alloc_reason
------------ ------- ------------ ----------------- -----------------
-----------------
304057512 363 837624 , callheap, freeable,
task parameter
150991488 144 1048552 , top call heap, freeable,
callheap
140727552 168 837664 , top call heap, freeable,
callheap
29881680 114 262120 , top uga heap, freeable,
session heap
Changes
Upgrade from 12.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |