Customer Interface Performance Issue: Poor Performance (Doc ID 1439350.1)

Last updated on OCTOBER 10, 2013

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.
*** Checked for relevance on 10-Oct-2013 ***

Symptoms

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
WHERE
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'


Changes

ATG RUP 7 upgrade.

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