Question on ALERTS

[DaveH]

If a DBMS_ALERT is sent by a database trigger, is there any negative implication to having no "receiver"?

And what, if anything, happens to the alert itself? Is it logged somewhere, taking up space? Or it it strictly a temporary message which can be intercepted for a few seconds, and then disappears into the bit bucket?

Dave

 

[Marco Kalter]

There is no negative side-effect if nobody is receiving the alerts. Anybody who is interested has to register for the alert, and if nobody has registered, this is not a problem. Only those sessions that are waiting for the alert when it occurs will receive it.

------------------
Marco Kalter
Allround Automations

 

[Sven]

Keep in mind, if two sessions are sending the
same alert with no commit, that the latter
session will wait on the first until the first session is comitted...

Sven