"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)
Last updated on JULY 24, 2017
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).
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