?
Solved

DBMS_AQ

Posted on 2013-11-10
5
Medium Priority
?
204 Views
Last Modified: 2013-11-14
Can anyone explain me the use of DBMS_AQ in simple terms?
0
Comment
Question by:sakthikumar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

743 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