My Oracle Support Banner

QMON (q00) Pga Memory Growing Very Large After Applied DBRU 19.12 Leading To ORA-04036 And ORA-25226 Errors. (Doc ID 2813205.1)

Last updated on JANUARY 11, 2022

Applies to:

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


You may encounter an increase in memory (PGA) of QMON worker processes (q00) after the database is patched with 19.12DBRU.

It may lead other processes to fail with ORA-04036 as well:


Errors in file /path/ORCL_j00v_30460.trc (incident=5905970) (PDBNAME=PDB1):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT


And eventually you can find ORA-25226 error to the SRVNTFN queue:

*** SERVICE NAME:(SYS$USERS) 2021-09-29T08:53:23.276472-07:00
*** MODULE NAME:(DBMS_SCHEDULER) 2021-09-29T08:53:23.276477-07:00
*** ACTION NAME:(AQ$_PLSQL_NTFN_423922493) 2021-09-29T08:53:23.276482-07:00
: Exception Occured, Error msg:
ORA-25226: dequeue failed, queue SYS.AQ_SRVNTFN_TABLE_Q_2 is not enabled for dequeue
ORA-06512: at "SYS.DBMS_AQIN", line 571



 Applied 19.12 DBRU.


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

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