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 OCTOBER 11, 2021

Applies to:

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

Symptoms

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:

 

2021-08-27T22:02:38.897563-07:00
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

 

Changes

 Applied 19.12 DBRU.

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


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