Deadlock on DBMS_ALERT_INFO

We are having a deadlock issue on DBMS_ALERT_INFO in a production database.

Did run ADDM report and also submitted SR to Oracle support. The recommendation is ‘The application code and logic need to be modified’.

Have sent the related info to the application vendor, but the vendor’s solution is only to increase application retries when deadlock occurs.

To prevent this kind of deadlocks, is there anything I can do as a DBA? Could anyone shed some light on this?

Thanks,
Lu

The following is from the trace file:

user session for deadlock lock 0X00000001D50D5148   sid: 2121 ser: 37862 audsid: 30482721 user: 0/SYS     flags: (0x100041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-     flags2: (0x8)
  pid: 57 O/S info: user: SYSTEM, term: FHM1PM64DBNA1, ospid: 76664     image: ORACLE.EXE (SHAD)
  O/S info: user: FHM1PR\fhm1plp28, term: FHM1PCTXAPSA1, ospid: 12832:13964, machine: FHM1PR\FHM1PCTXAPSA1

            program: PASPVTAA.exe
  application name: PASPVTAA.exe, hash value=521341192   Current SQL Statement:
  UPDATE DBMS_ALERT_INFO SET CHANGED = 'Y', MESSAGE = :B2 WHERE NAME = UPPER(:B1 ) Thanks,
Lu

--
http://www.freelists.org/webpage/oracle-l