My Oracle Support Banner

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.

Symptoms

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:

SELECT * FROM admin_list_wi WHERE ci_domain_ref = 0 AND wi_state = :1 ORDER BY wi_modify_date desc

 

SELECT * from ( select a.*, ROWNUM rnum FROM ( SELECT * FROM admin_list_cx WHERE ci_domain_ref = 0 AND ( UPPER( conversation_id ) LIKE :1 OR UPPER( index_1 ) LIKE :2 OR UPPER( index_2 ) LIKE :3 OR UPPER( index_3 ) LIKE :4 OR UPPER( index_4 ) LIKE :5 OR UPPER( index_5 ) LIKE :6 OR UPPER( index_6 ) LIKE :7 ) ORDER BY ci_modify_date desc ) a WHERE ROWNUM <= 20 ) WHERE rnum >= 0
SELECT * from ( select a.*, ROWNUM rnum FROM ( SELECT * FROM admin_list_cx WHERE ci_domain_ref = 0 ORDER BY ci_modify_date desc ) a WHERE ROWNUM <= 20 ) WHERE rnum >= 0

 


 

 

Changes

 

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