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 and later
Information in this document applies to any platform.


On B2B 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


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

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