AQ and DBMS_JOB for server side parallelism?

3004

I am using DBMS_JOBs to listen to a queue on 8.1.7. When something is queued one of the SNP processes that is listening dequeues the message and processes it using some stored procs. In this way messages that require a short time to process do not have to wait until messages that are longer have finished processing. This would be the case in a "single threaded" dequeueing system.

Basically I'm just looking for some validation on this approach - If anyone has any other suggestions, especially if you know of another way of spawning server side processes, I would be extremely grateful.

Thank you in advance,

Matt

3004

This approach is fine.
Oracle9i AQ allows you to register PL/SQL callbacks that will be invoked asynchronously (using DBMS_JOB) when a message is enqueued to a queue