Re: DBMS_JOB and 'near' real-time

On Sat, 14 Jan 2006 10:03:46 -0800, The House Dawg wrote:

> Aren't both AQ and replication built on top of DBMS_JOB? Is there an
> advantage in using the AQ layer of abstraction over the lower level
> DBMS_JOB? The DBMS_JOB package gets called by AQ anyways...

AFAIK,
- AQ is a data queue mechanism, guaranteeing that when a data set is   queued, it will arrive at the far end.

• Replication is a mechanism for selecting data to be moved (or queued) and ensuring it is loaded properly at the target.
• Job is a mechanism for scheduling and starting procedures and packages. Such as those involved in queueing and replication.

To me there intuitively doesn't seem much overlap. I'd appreciate a pointer to some doc or notes that supports or expands on your comment.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***