DBMS_AQ.Enqueue gives incorrect enqueue time 
Author Message
 DBMS_AQ.Enqueue gives incorrect enqueue time
Hi,

I have a problem with the DBMS_AQ.ENQUEUE procedure: Sometimes it works
OK, but sometimes it creates queue entries with an enqueue time several
hours in the past ... 8 hours and 27 minutes in the past, to be precise.

The system is Oracle 8.1.5.0.2 on SuSE linux 6.2

Has anybody seen this problem before? Any known fixes/workrounds?

TIA
SB



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Advanced Queuing: remote enqueuing/dequeuing

2. enqueue timeouts ?

3. enqueue waits

4. how to get a msgid from enqueue in Visual Basic (using oo4o)

5. advanced queueing - how to enqueue to remote queue

6. library cache lock | transaction enqueue lock

7. enqueue wait event

8. ST-enqueue problem

9. Advanced Queuing: remote enqueuing/dequeuing

10. Waited Too Long For Row Cache Enqueue Lock

11. constant monitoring and enqueues?

12. transaction enqueue lock


 
Powered by phpBB® Forum Software