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