Last updated on JULY 24, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 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
Million Knowledge Articles and hundreds of Community platforms