Slow Performance Of The BPEL Console
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.
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
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