Push signal from database to client
Dear Oracle experts,
in my scenario I would like a client application to react on changes of my Oracle database.
To achieve this we implemented on the client side a loop which queries the database every 200 ms to
discover changes within the database.
Since this may become a performance killer I would like the database to send a signal "My data changed" to
the connected clients to make them query the database only in case of changed data.
Do you know a mechanism to send such a signal to connected clients ?
Best regards,
Daniel