Poor Performance With PA: Offline Microsoft Project Data Upload (PAXCPWBC) Process
(Doc ID 2589055.1)
Last updated on SEPTEMBER 16, 2019
Applies to:Oracle Project Planning and Control - Version 12.2.6 and later
Information in this document applies to any platform.
Users experience poor performance with concurrent program PA: Offline Microsoft Project Data Upload (PAXCPWBC)
PAXCPWBC (PA: Offline Microsoft Project Data Upload) runs for days when trying to load large projects.
Additionally, it generates a large amount of UNDO segments.
The program spends much of its time executing the query below. It is full scanning the index PJI.PJI_FM_XBS_ACCUM_TMP1_N1 on the global temporary table PJI.PJI_FM_XBS_ACCUM_TMP6 .
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