Solved

DBMS_AQ

Posted on 2013-11-10
5
201 Views
Last Modified: 2013-11-14
Can anyone explain me the use of DBMS_AQ in simple terms?
0
Comment
Question by:sakthikumar
  • 3
  • 2
5 Comments
 
LVL 23

Expert Comment

by:David
ID: 39637708
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
 

Author Comment

by:sakthikumar
ID: 39637982
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
 
LVL 23

Accepted Solution

by:
David earned 500 total points
ID: 39641548
<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
 

Author Comment

by:sakthikumar
ID: 39647592
Second link is really good, I can understand well.
0
 

Author Closing Comment

by:sakthikumar
ID: 39647607
Thanks dvz good articles.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question