Scheduler Job For Removing AQ Subscriber Fails With ORA-04021
(Doc ID 2979780.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.12.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
ORA-04021: timeout occurred while waiting to lock object <QUEUE_TABLE>
2023-09-12T15:12:45.067869+10:00
Errors in file /u01/oracle/diag/rdbms/*/*/*.trc:
ORA-12012: error on auto execute of job "SYS"."AQ_JOB$_319890"
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 13572
2023-09-12T15:13:11.108818+10:00
Changes
The queue table receives heavy load every second
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 |