My Oracle Support Banner

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 6.2.1.0 and later
Information in this document applies to any platform.

Symptoms

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 = ............

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.