"Enq: TM Contention" Wait Event From the ADDTRSRC Object Resulting in Table Locking and Database Locks Which Downstream Into Performance Issues Copy/Pasting Projects or Inserting Activities in P6 EPPM Modules (P6, P6 Professional) (Doc ID 2098052.1)

Last updated on JULY 24, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
The following unindexed foreign key exists in the P6 EPPM schema:

TABLE_NAME: ADDTRSRC
CONSTRAINT_NAME: FK_ADDTRSRC_TASK
COLUMNS: TASK_ID

Running an Oracle ASH or AWR report can yield high activity on the "enq: TM contention" wait event from the ADDTRSRC object resulting in table locking and database locks which downstream into performance issues copy/pasting projects or inserting activities in P6 EPPM modules (P6, P6 Professional).

EXPECTED BEHAVIOR
-----------------------
For an index to be created on the unindexed foreign key to prevent "enq: TM contention" wait event contention which results in table locking that downstream into performance issues with copy/pasting projects or inserting activities in P6 EPPM modules (P6, P6 Professional).

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms