Slow Performance Of The BPEL Console (Doc ID 1448515.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle(R) BPEL Process Manager - 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

 


 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms