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 JULY 20, 2024
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
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
*** 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 |