Re: About DBMS_ALERT package...

From: <asprusch_at_my-dejanews.com>
Date: Fri, 24 Jul 1998 06:51:55 GMT
Message-ID: <6p9aub$ono$1@nnrp1.dejanews.com>

The dbms_alert.signal procedure will only signal the alert when the transaction commits. There are probably rollbacks in your code so that signaled alerts are removed. The other thing you've found is also documented in the dbms_alert package. Alerts will overwrite older alerts which were not fast enough consumed.
If you want to inform other sessions in a fifo behaviour you should use dbms_pipe. That's work without commit, and the message will transfer immediatly to the other session. No data will lost!

Best regards,
Andreas Prusch

In article <35B7551A.E9C1FF5D_at_sodalia.it>, Valentina Amadori <amadori_at_sodalia.it> wrote:
> This is a multi-part message in MIME format.
> --------------33227EB93D7AB64BF1C17178
> Content-Type: multipart/alternative; boundary="------------
90B7F6B837BB2860559CD555"
>
> --------------90B7F6B837BB2860559CD555
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I am using the DBMS_ALERT package of Oracle 7.3 on HP_UX 10.20.
>
> I have some indesidered behaviours:
>
> 1. The alert signal is always late of one transaction. I am alerted
>
> on the last but one transaction, not on the last. Why? This is not
>
> a good behaviour for a useful use!
>
> 2. Often the alert (defined in a trigger FOR EACH ROW) loses some modificated
records.
>
> The notifications, or "alerts", of database events are often partial,
specially
>
> if there are transactions too frequently. Do you confirm?
>
> My process have to be alerted when any database events occurs. But I wont
lose any modificated record!
>
> Do you know any mechanism. I am falling back to the triggers with a polling
combination...
>
> Thanks,
>
> Vale
>
> --
>
> =================================
>
> --------------90B7F6B837BB2860559CD555
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <HTML>
>
> <PRE>I am using the DBMS_ALERT package of Oracle 7.3 on HP_UX 10.20.</PRE>
>
> <PRE>I have some indesidered behaviours:</PRE>
>
> <PRE>1. The alert signal is always late of one transaction. I am alerted</PRE>
>
> <PRE>   on the last but one transaction, not on the last. Why? This
is not</PRE>
>
> <PRE>   a good behaviour for a useful use!</PRE>
>
> <PRE></PRE>
>
> <PRE>2. Often the alert (defined in a trigger FOR EACH ROW) loses some
modificated records.</PRE>
>
> <PRE>   The notifications, or "alerts", of database events are
often partial, specially</PRE>
>
> <PRE>   if there are transactions too frequently. Do you confirm?
</PRE>
>
> <PRE></PRE>
>
> <PRE>My process have to be alerted when any database events occurs. But I
wont lose any modificated record!</PRE>
>
> <PRE>Do you know any mechanism. I am falling back to the triggers with a
polling combination...</PRE>
>
> <PRE></PRE>
>
> <PRE>Thanks,</PRE>
>
> <PRE>        Vale</PRE>
>
> <PRE>-- 
>      
>        

=================================</PRE>

>  </HTML>
>
> --------------90B7F6B837BB2860559CD555--
>
> --------------33227EB93D7AB64BF1C17178
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Amadori Valentina
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Amadori Valentina
> n: Valentina;Amadori
> org: Sodalia S.p.A
> adr;dom: via Valentina Zambra,1;;;Trento;Italia;38100;
> email;internet: amadori_at_sodalia.it
> title: Dep. DE/NAM
> tel;work: +39-461-316166
> tel;fax: +39-461-316401
> note: III piano - stampante adige
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> version: 2.1
> end: vcard
>
> --------------33227EB93D7AB64BF1C17178--
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 24 1998 - 01:51:55 CDT