The Number of Records in the REFRDEL Table Continues to Grow Even Though the DAMON Background Job Runs Successfully
(Doc ID 2106967.1)
Last updated on JANUARY 14, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 220.127.116.11 and later
Primavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Information in this document applies to any platform.
The REFRDEL table continues to accumulate records which are not being purged as expected by the data_monitor (DAMON) background job, and the following query is one of the top consumers of database resources, negatively impacting system performance:
SELECT COUNT(*) FROM DUAL WHERE EXISTS (SELECT * FROM REFRDEL WHERE DELETE_DATE > :B2 AND PROJ_ID = :B1 AND TABLE_NAME IN
('PROJWBS','TASK','TASKRSRC','PROJECT', 'PROJCOST','TASKFIN','TRSRCFIN','WBSRSRC','WBSRSRC_QTY') )
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