Database Deadlocks Occurring On the Tables T_PRM_DAT AND T_ACT_APP
(Doc ID 2704175.1)
Last updated on SEPTEMBER 03, 2020
Applies to:Oracle Agile Engineering Data Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
On several occasions the administrator is getting a deadlock condition in the Oracle database and are unable to determine what the root cause may be. The tables that are involved are T_PRM_DAT and T_ACT_APP. Here is the SQL that is locked :
UPDATE T_PRM_DAT SET PRM_TIMESTAMP = SYSDATE and DELETE FROM
T_ACT_APP WHERE C_ID = ............
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document