Hello,
I have a problem with an application consisting of a C/Pro*C part and several PL/SQL-packages.
The C-part is sending / receiving telegrams via tcp/ip and uses DBMS_ALERT to communicate with the PL/SQL-part.
There are also several other PL/SQL-packages of other applications in the database that are relying heavily on DBMS_ALERT.
Now the problem is, that sometimes the application seems to block the whole DBMS_ALERT-mechanism and the database has to be restarted in order to get DBMS_ALERT running again.
The logs show a call to DBMS_ALERT.REMOVE is being executed as the last step.
The problem might be a timing issue because it appears if many telegrams are being received in short succession, but I have not been able to get closer to the cause.
As restarting the database every time this problem occurs is not a solution, I do very much appreciate any help narrowing down the cause of the issue.
Thank you in advance!