"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 FEBRUARY 28, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
The following unindexed foreign key exists in the P6 EPPM schema:
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).
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).
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