Originally posted by ssmith
The job is processing messages, therefore checking a table to see if it needs to process any messages. What about using dbms_lock.sleep(1) within the procedures. What effect will this have?
Oracle introduced powerful queuing mechanisms where messages can be exchanged between different programs. They called it Advanced Queuing AQ.