Solved

DBMS_AQ

Posted on 2013-11-10
5
197 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now