B2B 10g: Performance Issue With a Repetitive SQL Statement - TIP_TradingPartnerIdentific_ra

(Doc ID 1184569.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Application Server Integration B2B - Version: 10.1.2.3.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

On B2B 10.1.2.3 MLR14.

It has been noticed the following query executed 54,087 times in 1 hour and consumed about 20 minutes of performance test:

select ID , CLASSTYPE , NOTM , ISSEEDED , FCO , LifeCycleState , description
, description_clob , value, tradingpartner, partyidentificationtype
from TIP_TradingPartnerIdentific_ra t
where ( partyidentificationtype= :1 )

Also this query was running even when the server was idle. Currently "TIP_TradingPartnerIdentific_ra" is a materialized view based on Tables:

- TIP_TradingPartnerIdentific_rt
- TIP_configuration_t

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