How to make my app receive asynchronous notifications from the database?
February 6th, 2006 By Vadim Bobrov
Use DBMS_ALERT package. Rather than polling your database at regular intervals wasting network bandwidth, have a trigger report any changes back to you when they occur using DBMS_ALERT package. You can create a second thread in your application and have it listen and respond to incoming notifications about database changes. This way you improve both your network utilization and application responsiveness.
Vadim Bobrov
Oracle Database Tools
http://www.fourthelephant.com