| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes Pacheco
Sent: Wednesday, March 10, 2004 12:31 PM
To: oracle-l_at_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
 |
 |