From oracle-l-bounce@freelists.org Wed Mar 10 15:02:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2AL2pG03645 for ; Wed, 10 Mar 2004 15:02:51 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2AL2oo03627 for ; Wed, 10 Mar 2004 15:02:50 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EEE4A395FA5; Wed, 10 Mar 2004 16:00:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 10 Mar 2004 15:59:26 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ddbcinc.com (unknown [216.222.6.50]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7757C395E71 for ; Wed, 10 Mar 2004 15:59:19 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: When you use advanced queues overmore as a message system Date: Wed, 10 Mar 2004 14:07:38 -0700 Message-ID: <87E9F113CEF1D211A4C3009027301874195D24@ddbcinc.ddbc.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: When you use advanced queues overmore as a message system thread-index: AcQG2LO1MoY67/J8S3eATydkAHoJ9wAAifsAAAIK9XAFrom: "Justin Cave (DDBC)" To: X-archive-position: 393 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jcave@ddbcinc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l From: oracle-l-bounce@freelists.org Credit where credit is due, the article that I was referring to was on OTN. It was Cameron O'Rourke's "Do You Queue?" http://otn.oracle.com/oramag/oracle/04-mar/o24dev_trends.html Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Justin Cave (DDBC) Sent: Wednesday, March 10, 2004 1:13 PM To: oracle-l@freelists.org Subject: RE: When you use advanced queues overmore as a message system There are a number of applications where you may want some processing to happen but you don't want users to necessarily wait for the results of that processing. One of the better AQ case studies (I'm guessing it was an OTN article, but I'm not 100% sure) I've seen involved a call center application. When customers called in to change some attribute of their account, the system was originally set up so that the operator (and customer) had to wait while the system did a complete verification that the account was consistent (if you change addresses and move out of state, for example, your long distance plan may no longer be valid), which took, say 30 seconds. Since 99% of the time the results were that everything was OK, the application was modified to assume that the changes would be valid, do the check in the background, and, depending on when the results came back, either correct the error later on in the call or call the customer back. The result was that they saved a lot of time that was previously wasted for the machine. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Cachito Reyes Pacheco Sent: Wednesday, March 10, 2004 12:31 PM To: oracle-l@freelists.org Subject: When you use advanced queues overmore as a message system Hi, sorry I had read the documentation, and an article I found http://www.oug-ottawa.org/oougpresentations/2003jan23_advanced_queuing.zip But I still can't figure out when you SHOULD use it, I don't know if you could please give an example about the use of this features. Please ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------