Hang Due To Library Cache Lock in DBMS_AQ.ENQUEUE For Non Existing Queue Table
(Doc ID 2533298.1)
Last updated on JANUARY 15, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
PLSQL procedure indefinitely hangs in dbms_aqadm.create_queue with wait event 'library cache pin' when enqueue done for a non existent queue.
The steps followed in the plsql procedure are :
1. dbms_aq.enqueue(queue_name .... --> non existing queue
2. dbms_aqadm.create_queue_table( ... -->
3. dbms_aqadm.create_queue(queue_name .... -> with same queue name as no.1
---
Problem is in dbms_aq.enqueue() does not release lock even the queue is not exist.
Changes
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 |