Process below describes how to organize queue
Create queue user
Check parameters job_queue_processes and aq_tm_processes (al least - 4 for each)
Create queue table in user scheme above. (Check free rooms in the tablespace)
Create queue (dbms_aqadm.create_queue). Check created queue (user_queue)
Add subscribers
Queue operations
start/stop queue
enqueue
dequeue
set delay
set expiration
set conditions
Propagation queue
Transformation queue
No comments:
Post a Comment