[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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