From oracle-l-bounce@freelists.org Thu Apr 14 05:47:18 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3EAlIq5023353 for ; Thu, 14 Apr 2005 05:47:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3EAlIem023348 for ; Thu, 14 Apr 2005 05:47:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D880C96B40; Thu, 14 Apr 2005 04:45:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05190-09; Thu, 14 Apr 2005 04:45:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E90896B2B; Thu, 14 Apr 2005 04:45:05 -0500 (EST) Message-ID: <425E3B2B.2050508@aldratech.com> Date: Thu, 14 Apr 2005 12:43:07 +0300 From: Radu-Adrian Popescu Organization: Aldratech Ltd. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Cc: zoran_martic@yahoo.com Subject: Re: Oracle Advanced Queue and Java Messaging System(JMS) References: <20050412104202.45285.qmail@web52605.mail.yahoo.com> In-Reply-To: <20050412104202.45285.qmail@web52605.mail.yahoo.com> Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 18450 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: radu.popescu@aldratech.com Precedence: normal Reply-To: radu.popescu@aldratech.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Martic Zoran wrote: > Radu, > >>Also how many queues, producers and consumers do you >>have ? > > 4 queues. 2 are with 1 producer and 4 or more > consumers, 2 are with 4 or more producers and 1 > consumer. This was good enough for our customers > because the bottleneck was in some other integrated > systems :) > Thank you for the reply, very informative. I've a question for you regarding the multiple consumers on the same queue. How are the messages distributed between these consumers ? Does each consumer of this queue get to see each message ? I think not. Therefore is it true that having more than one consumer on a queue makes sense only when you want to distribute the processing of the queue messages to multiple processes (=consumers), for reasons such as splitting the load etc ? The JMS specification says: "Although it is possible to have two sessions with a QueueReceiver for the same queue, JMS does not define how messages are distributed between the QueueReceivers." Does Oracle AQ (whether using or not JMS) define this ? Do you even care about this, or it's of no relevance, since you simply want to distribute the work of processing messages between several consumers and care not what messages goes to where ? > If you want to be faster you will go with bulk enq/deq > (DML) in 10g. > Thanks in advance, Kind regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 -- http://www.freelists.org/webpage/oracle-l