My Oracle Support Banner

B2B 10g: Performance Issue With a Repetitive SQL Statement - TIP_TradingPartnerIdentific_ra (Doc ID 1184569.1)

Last updated on MARCH 24, 2019

Applies to:

Oracle B2B 10g (Business to Business) - Version 10.1.2.3.0 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:


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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.