Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alternative to DBMS_ALERT that implements FIFO?
A copy of this was sent to r22525_at_email.sps.mot.com
(if that email address didn't require changing)
On Mon, 01 Feb 1999 13:51:06 GMT, you wrote:
>Is there an alternative to DBMS_ALERT that will queue up the alerts?
>I like the transactional nature of DBMS_ALERT (only signals on commit),
>but I don't want to lose any alerts (DBMS_ALERT only keeps latest on a given
>signal).
>
>Any help would be appreciated.
>
>Wayne
>r22525_at_email.sps.mot.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
if you have O8, look at the advanced queues. It does this.
you could achieve this using dbms_jobs if you wanted also.
dbms_jobs are transactional (if you queue a job and rollback, the job goes away, if you commit, it will run).
you could queue a dbms_job to put a message in a pipe and have your process that waits for an alert now wait for a pipe message instead. you could use dbms_jobs to make pipes 'transactional'. it'll have the benefit that dbms_job.submit() won't serialize as well (as a call to dbms_alert will -- only one session at a time can signal a named event with dbms_alert).
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Feb 01 1999 - 08:10:38 CST