Slow Performance When Running Project Summarize Job Caused by 'Enq: TX - Row Lock Contention'
(Doc ID 2268607.1)
Last updated on OCTOBER 07, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 184.108.40.206 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 220.127.116.11 and later
Information in this document applies to any platform.
Project Summarize job is taking around 10 minutes to complete
In AWR report, Below 2 queries in row lock `enq: TX - row lock contention
delete from sumtrsrc where proj_id is null and role_id = :1;
delete from sumtrsrc where proj_id is null and rsrc_id = :1;
Each Project Summarize job should be completed quickly.
The issue can be reproduced at will with the following steps:
1. Set up P6Service as separate JVM process
2. JT_SUM concurrent thread is 2 (default)
3. Observe Pending Summarize Job will be picked up and run
The issue has the following business impact:
Due to this issue, users cannot summarize project efficiently.
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