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.
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:
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