Home » Server Options » Streams & AQ » [Queuing] parallel consumer processes
[Queuing] parallel consumer processes [message #246358] Wed, 20 June 2007 13:07 Go to next message
akull82
Messages: 3
Registered: May 2007
Junior Member
Hi,

I'm new in Advanced Queuing.
I'm using an queue with async. notification.
My callback procedure will be called for every message, but its everytime the same job, so only one message will be procced at one time.
Is it possible to configure oracle, to use more processes.
I don't mean dispatch the same message to many consumers.

Anybody out there who knows ??

André
Re: [Queuing] parallel consumer processes [message #246934 is a reply to message #246358] Fri, 22 June 2007 09:38 Go to previous message
akull82
Messages: 3
Registered: May 2007
Junior Member
the answer is simple,

ALTER SYSTEM SET job_queue_processes = 8;


an 4 processes will be used, but why only 4 not 8 ??

If I switch job_queue_processes to 10, 5 processes will be used.


Previous Topic: Streams in Enterprise Manager
Next Topic: ORA-26773: Invalid data type for column "malformed redo"
Goto Forum:
  


Current Time: Thu Mar 28 03:26:25 CDT 2024