R12.2:PA:Slow Performance In Projects Navigation

(Doc ID 2322015.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Information 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

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