Customer Interface Performance Issue: Poor Performance
(Doc ID 1439350.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Trading Community - Version 188.8.131.52 and later
Information in this document applies to any platform.
Performance issue with Customer Interface program.
Tkprof shows below query as expensive:
UPDATE FND_STATS_HIST SET PARALLEL = :B9 , REQUEST_ID = :B8 , REQUEST_TYPE =
:B7 , LAST_GATHER_START_TIME = SYSDATE, LAST_GATHER_DATE = '',
LAST_GATHER_END_TIME = '', EST_PERCENT=:B6
SCHEMA_NAME = UPPER(:B5 ) AND OBJECT_NAME = UPPER(:B4 ) AND (PARTITION =
UPPER(:B3 ) OR :B3 IS NULL) AND ( COLUMN_TABLE_NAME = UPPER(:B2 ) OR :B2 IS
NULL) AND OBJECT_TYPE = UPPER(:B1 ) AND HISTORY_MODE='L'
ATG RUP 7 upgrade.
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