Home / server / Questions / 324667
In Process
ftkalcevic
Asked: 2011-10-24 21:30:11 +0800 CST

Does DBMS_ALERT work correctly on an oracle RAC cluster?

  • 772

Can anyone confirm whether the oracle DBMS_ALERT package works correctly in a RAC envirnoment.

That is, if I have a DBMS_ALERT.WAITONE() on all instances, then I do a DBMS_ALERT.SIGNAL(), will all nodes be signalled?

oracle

1 Answers

  1. Yes.

    Oh, you wanted more detail than that?

    See this blog post, complete w/ test case: http://vitspinka.blogspot.com/2008/04/dbmsalert-on-rac.html

    • 0