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 126.96.36.199.0 to 188.8.131.52.0 [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:
*** 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