Slow Performance When Running Project Summarize Job Caused by 'Enq: TX - Row Lock Contention'
Last updated on JUNE 01, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 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.
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