Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

DBMS_AQ

Can anyone explain me the use of DBMS_AQ in simple terms?
0
sakthikumar
Asked:
sakthikumar
  • 3
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
With tongue in cheek, that's like getting a simple explanation of the U.S. Government....

Since Oracle 8i (I think), there has been a native method to send and receive messages between the database and outside services.  In 10g, Oracle Streams is the Advanced Queueing (AQ) solution.

In PL/SQL, the DBMS_DQ package bundles the common enqueing and dequeing services for the messaging.

There's little in the E-E KB to offer you; I found http://www.oracle-developer.net/display.php?id=411 to be useful, and as always, there's the Oracle documention: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_aq.htm
0
 
sakthikumarAuthor Commented:
What kind of messages and how it is transferred, can you give a simple example.

Because you know oracle has procedures, functions etc., that can give information when called. how this is going to be different.?
0
 
DavidSenior Oracle Database AdministratorCommented:
<Grins> You've picked one of the more difficult features (to me) in Oracle -- in 20 years I've never been on a site that's used this.  Other experts are more than welcome to weigh in.

Your PL/SQL "information" is predominantly internal to the database instance.  A procedure might use dbms_output to put lines on SYSOUT -- or simply echo short messages to the log for debugging.

Streams and AQ refer to message strings sent out of, and in to, the Oracle instance.  In the source following, an example is to pass a string to a Java program.

http://www.idevelopment.info/data/Oracle/DBA_tips/Advanced_Queuing/AQ_2.shtml
and
http://docs.oracle.com/cd/B19306_01/server.102/b14229/strms_over.htm#CHDGDGDI
0
 
sakthikumarAuthor Commented:
Second link is really good, I can understand well.
0
 
sakthikumarAuthor Commented:
Thanks dvz good articles.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now