Customer Interface Performance Issue: Poor Performance
Last updated on OCTOBER 10, 2013
Applies to:Oracle Trading Community - Version 126.96.36.199 and later
Information in this document applies to any platform.
*** Checked for relevance on 10-Oct-2013 ***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms