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 22.214.171.124 and later
Information in this document applies to any platform.
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.
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