R12.2:PA:Slow Performance In Projects Navigation
(Doc ID 2322015.1)
Last updated on OCTOBER 28, 2022
Applies to:
Oracle Project Foundation - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.4 version, User Interface
ACTUAL BEHAVIOR
---------------
25961730>Slow Performance in Projects Navigation
When select the Project List and also picking a particular project, the below sql statement is taking a
long time to run:
SQL ID: capqvzda8yabd Plan Hash: 2213800308
SELECT /*+ QID01-bulk */ DISTINCT G.INSTANCE_TYPE
FROM
FND_GRANTS G WHERE G.OBJECT_ID = :B7 AND G.INSTANCE_TYPE IN ( 'GLOBAL',
'SET', 'INSTANCE') AND (G.GRANTEE_TYPE = 'GLOBAL') AND ( (:B6 = -1) OR (
EXISTS (SELECT 'X' FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE
CMF.FUNCTION_ID = :B6 AND CMF.MENU_ID = G.MENU_ID ) ) ) AND (
G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = :B5 ) AND ( G.CTX_RESP_ID = -1 OR
G.CTX_RESP_ID = :B4 ) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID =
:B3 ) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = :B2 ) AND G.START_DATE <=
SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE > :B1 )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1203 0.09 0.09 1 4 0 0
Fetch 1203 86.97 87.36 0 386130 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2407 87.07 87.46 1 386134 0 0
Cause
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
Symptoms |
Cause |
Solution |
References |