Slow Performance Of The BPEL Console
(Doc ID 1448515.1)
Last updated on NOVEMBER 18, 2019
Applies to:Oracle(R) BPEL Process Manager 10g - Version 10.1.3.5.0 to 10.1.3.5.0
Information in this document applies to any platform.
The BPEL console is very slow in getting information from the DB.
Analyzing by DB side, it seems to be triggered when searching using Order numbers in the Instances tab and when users pull up the "Activities" tab.
These queries seem to be querying a view which in turn is made up of joins on several key tables that are likely to grow drastically. The queries are listed below:
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