Guest User

Untitled

a guest
Apr 25th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. CREATE_QUEUE_TABLE (
  2. queue_table => 'AQUSER.event_message_queue_qt',
  3. queue_payload_type => 'AQUSER.EventMessageType',
  4. sort_list => 'ENQ_TIME, PRIORITY');
  5.  
  6. CREATE_QUEUE (
  7. queue_name => 'AQUSER.event_message_queue',
  8. queue_table => 'AQUSER.event_message_queue_qt',
  9. max_retries=> 10,
  10. retry_delay=> 600);
  11.  
  12. CREATE_QUEUE (
  13. queue_name => 'AQUSER.event_message_queue_ex_q',
  14. queue_table => 'AQUSER.event_message_queue_qt',
  15. queue_type => DBMS_AQADM.EXCEPTION_QUEUE);
  16.  
  17. select * from event_message_queue_qt
  18. where Q_NAME = 'event_message_queue_ex_q'
  19. and MSGID = '6AA2E0C9A14ABA97E053119A14333514'
  20.  
  21. select
  22. (select username from v$session where sid=a.sid) blocker,
  23. a.sid,
  24. ' is blocking ',
  25. (select username from v$session where sid=b.sid) blockee,
  26. b.sid
  27. from v$lock a, v$lock b
  28. where a.block = 1
  29. and b.request > 0
  30. and a.id1 = b.id1
  31. and a.id2 = b.id2;
Add Comment
Please, Sign In to add comment