Opening Any Project Takes 2 Times Longer After Upgrade to 23.6 (Doc ID 2969238.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

Opening any project, after the recent upgrade from 23.3 to 23.6, takes twice as long as it did before the upgrade.
Opening a project went from 15 seconds to 30 seconds.

EXPECTED BEHAVIOR

Projects should not be taking longer to open than they did before the upgrade.

2 longest running statements from Session Tracker:

Select /*+ index(st PK_TASK)*/ distinct st.* from task st, project p, taskpred tp, projshar ps where tp.pred_proj_id = p.proj_id and tp.pred_task_id = st.task_id and ps.proj_id = tp.proj_id and p.proj_id = st.proj_id and p.orig_proj_id is NULL and ps.session_id = XXXXXX and p.proj_id not in (select proj_id from projshar where session_id = XXXXXX)
response length=4368
(16 seconds)
 
Select /*+ index(st PK_TASK)*/ distinct st.* from task st, project p, taskpred tp, projshar ps where tp.proj_id = p.proj_id and tp.task_id = st.task_id and ps.proj_id = tp.pred_proj_id and p.proj_id = st.proj_id and p.orig_proj_id is NULL and ps.session_id = XXXXXX and p.proj_id not in (select proj_id from projshar where session_id = XXXXXX)
response length=4368
(16 seconds)

STEPS

The issue can be reproduced at will with the following steps:
1. Launch P6 Professional via CloudConnect
2. Open any project.
3. Observe the process takes about 30 seconds (an increase from 15 seconds after the upgrade to version 23.6).

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.