how to check queue status
616941Dec 11 2009 — edited Dec 11 2009Dear expert,
1) may i know is there anyway for me to check queue status? example is the queue enqueue and dequeue is enable or not.
2) may i know is there any website i can refer oracle queue table defination. so i can understand more on my queue table.
for example my queue is like below.
begin
DBMS_AQADM.start_queue(
queue_name => 'ABC',
enqueue => true,
dequeue => true);
end;
is there anyway for me to knwo the
enqueue => ?,
dequeue => ?
Best Regard
Terence chua
Edited by: Terence Chua on Dec 11, 2009 4:52 PM