From oracle-l-bounce@freelists.org Thu Jun 23 04:31:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5N9VgP2030610 for ; Thu, 23 Jun 2005 04:31:42 -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 j5N9VgNi030606 for ; Thu, 23 Jun 2005 04:31:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C46A1C2C1E; Thu, 23 Jun 2005 03:28:16 -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 16471-06; Thu, 23 Jun 2005 03:28:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9767A1C2BB7; Thu, 23 Jun 2005 03:28:15 -0500 (EST) Message-ID: From: Amihay Gonen To: "Oracle-L (oracle-l@freelists.org)" Subject: q:Using AQ effectively ? Date: Thu, 23 Jun 2005 11:29:33 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C577CD.AEA001D0" X-archive-position: 21544 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: AmihayG@ectel.com Precedence: normal Reply-To: AmihayG@ectel.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.3 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_RED,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C577CD.AEA001D0 Content-Type: text/plain Hi , I've to implement an actions system. I've one side which put action in Advance queue system , and other side (c++ application ) that get the action and do it. Each action has type which use to define connection between action and application (For example 'EMAIL' -- email application) I've two options to do it in AQ : 1. Define subscriber with a rule DBMS_AQADM.ADD_SUBSCRIBER ( queue_name => 'Queue' , subscriber => new sys.aq$_agent('EMAIL',null,null), rule => 'tab.user_data.type=''EMAIL'' ' ; 2. deqeue user subscriber name. Or 1. When defining subscriber leave the rule empty. 2. on the DBMS_AQ.ENQUEUE command use message_properties_t.recipient-_list to define which subscriber should get the message. for example: declare ... a AQ$_RECIPIENT_LIST_T := new AQ$_RECIPIENT_LIST_T(new sys.aq$_agent('EMAIL',null,null)); .... I wonder with of the option will has better performance ? And what the best practice in the area ? Amihay Gonen DBA, 972-3-9268280 Be there ... -> http://golan/Forum%20DBA/default.aspx ------_=_NextPart_001_01C577CD.AEA001D0 Content-Type: text/html

Hi ,
I've to implement an actions system.

I've one side which put action in Advance queue system , and other
side (c++ application ) that get the action and do it. Each action has
type which use to define connection between action and application
(For example 'EMAIL' -- email application)

I've two options to do it in AQ :

1. Define subscriber with a rule
DBMS_AQADM.ADD_SUBSCRIBER (
queue_name => 'Queue' , subscriber => new
sys.aq$_agent('EMAIL',null,null),
rule => 'tab.user_data.type=''EMAIL'' ' ;
2. deqeue user subscriber name.

Or
1. When defining subscriber leave the rule empty.
2. on the DBMS_AQ.ENQUEUE command use
message_properties_t.recipient_list to define which subscriber should
get the message. for example:
declare
...
a AQ$_RECIPIENT_LIST_T := new AQ$_RECIPIENT_LIST_T(new
sys.aq$_agent('EMAIL',null,null));
....

I wonder with of the option will has better performance ? And what the
best practice in the area ?

Amihay Gonen
DBA,
972-3-9268280

Be there ... -> http://golan/Forum%20DBA/default.aspx

------_=_NextPart_001_01C577CD.AEA001D0-- -- http://www.freelists.org/webpage/oracle-l