Forum Stats

  • 3,814,956 Users
  • 2,258,936 Discussions
  • 7,892,896 Comments

Discussions

AQ and DBMS_JOB for server side parallelism?

3004
3004 Member Posts: 204,171 Green Ribbon
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

Comments

This discussion has been closed.