Re: Queues
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, joe_dba@xxxxxxxxxxx
- Date: Wed, 25 Aug 2010 11:51:23 -0700 (PDT)
use a queue when you want a publish-subscribe model. (asynchronous)
if you try to code a mechanism for multiple processes to pluck messages off a
heap organized table, ensuring that no more than one process picks up each
message, you are recreating what a queue automatically does for you.
there are other use cases as well for automatic notification/invocation of
pl/sql upon arrival of a message in an asynchronous way that make queues
indispensable.
who told you that you needed a queue?
Job
--- On Wed, 8/25/10, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
From: Joe Smith <joe_dba@xxxxxxxxxxx>
Subject: Queues
To: oracle-l@xxxxxxxxxxxxx
Date: Wednesday, August 25, 2010, 11:33 AM
I have been reading the PDFs and documents on MOS, but can someone tell me the
difference or advantage of using Queues instead of writing messages to a
regular heap-organized Oracle table?
Or what is the real advantage of queues that I am missing?
Other related posts:
