RE: When you use advanced queues overmore as a message system
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 14:07:38 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Justin Cave (DDBC)
Sent: Wednesday, March 10, 2004 1:13 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Juan Cachito Reyes Pacheco
Sent: Wednesday, March 10, 2004 12:31 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
