Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE_QUEUE_TABLE (
- queue_table => 'AQUSER.event_message_queue_qt',
- queue_payload_type => 'AQUSER.EventMessageType',
- sort_list => 'ENQ_TIME, PRIORITY');
- CREATE_QUEUE (
- queue_name => 'AQUSER.event_message_queue',
- queue_table => 'AQUSER.event_message_queue_qt',
- max_retries=> 10,
- retry_delay=> 600);
- CREATE_QUEUE (
- queue_name => 'AQUSER.event_message_queue_ex_q',
- queue_table => 'AQUSER.event_message_queue_qt',
- queue_type => DBMS_AQADM.EXCEPTION_QUEUE);
- select * from event_message_queue_qt
- where Q_NAME = 'event_message_queue_ex_q'
- and MSGID = '6AA2E0C9A14ABA97E053119A14333514'
- select
- (select username from v$session where sid=a.sid) blocker,
- a.sid,
- ' is blocking ',
- (select username from v$session where sid=b.sid) blockee,
- b.sid
- from v$lock a, v$lock b
- where a.block = 1
- and b.request > 0
- and a.id1 = b.id1
- and a.id2 = b.id2;
Add Comment
Please, Sign In to add comment