Hello all, 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 -- //www.freelists.org/webpage/oracle-l