Basics on Advanced Queuing

From: Mahadevan, Sundar <Sundar.Mahadevan_at_bmo.com>
Date: Wed, 20 Jan 2010 17:17:36 -0500
Message-ID: <8B457B2513B0E648AE169BF02182F03A8690106185_at_BMFGEXCMB02.adroot.bmogc.net>

Hi List,
Hope all is well. I am just starting to learn about Advanced Queuing. The following were the documents that I read to get a hint on Advanced Queuing.

Oracle 11g Advanced queuing white paper

http://en.wikipedia.org/wiki/Message_queue
http://it.toolbox.com/blogs/oracle-guide/advanced-queues-and-streams-a-definition-in-plain-english-3677
http://www.oracle-developer.net/display.php?id=411

I searched more on google for basics on AQ but not much help. Unfortunately, I was unable to get the basic understanding of advanced queuing due to the fact that I cannot imagine how Message queues work (business logic). To my understanding, streams are used for replication while advanced queuing is used for Message queues. And btw, streams internally use AQ. The following are my question pertaining to Advanced Queuing(message queues):

1. Is AQ happening between 2 databases or within a single database but 2 different schemas?
2. Is it imperative that dblinks are created for AQ to work or you do not need dblinks for AQ to work(if AQ happens between 2 databases)
3. If AQ happens within a single database but 2 different schemas then a grant all on the other user's objects can be used for message queues. So what is the idea here?

Apologies if my questions are silly. I would appreciate if anyone could reply back with the basics of AQ in simple terms and the business logic behind it.

Thanks a ton.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 20 2010 - 16:17:36 CST