Showing posts with label Queue. Show all posts
Showing posts with label Queue. Show all posts

30 May 2010

Oracle Advanced Queue

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)