ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT With heaps: "koh dur heap d " and chunks: "qmnfaPre:qmnsm3" reported on 12.2.0.1 (Doc ID 2638231.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

What
______________
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

Where
________________
--Alert log--

2019-11-21T07:48:06.011599+00:00
Errors in file ... ora_10535.trc  (incident=54062):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Errors in file ..._ora_10535.trc  (incident=54063):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2019-11-21T07:48:18.997069+00:00
Errors in file .....ORATFC_ora_10535.trc  (incident=54064):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Errors in file .....ORATFC_ora_10535.trc  (incident=54065):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2019-11-21T07:48:33.975096+00:00
PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 4096 MB

--Trace file--

Trace file ....
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME:    /opt/oracle/product/12.2.0/db_home
System name: Linux
Release: 4.4.73-5-default
Version: #1 SMP Tue Jul 4 15:33:39 UTC 2017 (b7ce4e4)
Machine: x86_64
Instance name: ORATFC
Redo thread mounted by this instance: 1
Oracle process number: 63
Unix process pid: 10535, image: ...

*** 2019-11-21T07:27:04.586409+00:00
*** SESSION ID:(603.61040) 2019-11-21T07:27:04.586423+00:00
*** CLIENT ID:() 2019-11-21T07:27:04.586427+00:00
*** SERVICE NAME:(SYS$USERS) 2019-11-21T07:27:04.586430+00:00
*** MODULE NAME:(JDBC Thin Client) 2019-11-21T07:27:04.586433+00:00
*** ACTION NAME:() 2019-11-21T07:27:04.586437+00:00
*** CLIENT DRIVER:(jdbcthin) 2019-11-21T07:27:04.586440+00:00

Process may have gone over pga_aggregate_limit
Just allocated 65536 bytes
Dumping short stack in preparation for potential ORA-4036
----- Abridged Call Stack Trace -----
ksedsts()+346<-ksm_pga_limit_short_stack()+1084<-ksm_check_over_limit()+2128<-ksmarfg()+261<-kgh_invoke_alloc_cb()+202<-kghgex()+1460<-kghfnd()+362<-kghalo()+4582<-kghgex()+500<-kghfnd()+362<-kghalo()+4582<-kghgex()+500<-kghfnd()+362<-kghalo()+4582<-kghgex()+500
<-kghfnd()+362<-kghalo()+4582<-kghgex()+500<-kghfnd()+362<-kghprmalo()+760
----- End of Abridged Call Stack Trace -----
=======================================
PRIVATE MEMORY SUMMARY FOR THIS PROCESS
---------------------------------------
******************************************************
PRIVATE HEAP SUMMARY DUMP
805 MB total:
  804 MB commented, 303 KB permanent
  462 KB free (0 KB in empty extents),
    798 MB,   1 heap:    "session heap   "          
------------------------------------------------------
Summary of subheaps at depth 1
803 MB total:
  803 MB commented, 151 KB permanent
  527 KB free (6 KB in empty extents),
    794 MB,   3 heaps:   "koh dur heap d "            465 KB free held
------------------------------------------------------
Summary of subheaps at depth 2
794 MB total:
  710 MB commented, 235 KB permanent
   83 MB free (0 KB in empty extents),
    778 MB, 1359705 chunks:  "qmnfaPre:qmnsm3           " 82 MB free held

signalling ORA-4036 interrupt
DDE: Problem Key 'ORA 4036' was flood controlled (0x2) (incident: 54062)
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
DDE: Problem Key 'ORA 4036' was flood controlled (0x2) (incident: 54063)
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

*** 2019-11-21T07:48:18.974782+00:00
signalling ORA-4036 interrupt
DDE: Problem Key 'ORA 4036' was flood controlled (0x2) (incident: 54064)
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
DDE: Problem Key 'ORA 4036' was flood controlled (0x2) (incident: 54065)
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.