OEM 13.4: "Stream AQ:index Block Pin/row Lock Wait Events" Observed in 19c Repository Database
(Doc ID 2772649.1)
Last updated on JANUARY 17, 2023
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
OEM 13.4 with 19c RAC Repository DB
Repository database having massive wait events on:
AQ:index block pin/row lock wait for sqlid 747d8puab2h4u with text: BEGIN DBMS_APPLICATION_INFO.SET_ACTION(:1 ); EM_LOADERJOB.dequeu_job(:2 ,:3 ,:4 ,:5 ,:6 ,:7 ); END;
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 |
Cause |
Solution |
References |