SOA 11g - EM console performance issues

Scenario and Symptoms:

The BPEL Engine Audit level is set to Development.

The BPEL engine is load tested with some huge number of transactions causing to generate large number of instances in the dehydration store (SOAINFRA Schema)

Below activities in EM console take time:

1.       EM Login Page Load time

2.       Time taken for logging in to the EM

3.       Time taken to render homepage for SOAINFRA

4.       Expanding the SOAINFRA and each partition within

5.       Time taken to render home page for each deployed composite

6.       Time taken to render details for each instance of any deployed composite

Cause:

Large number of instances in the dehydration store with audit level set to Development. When you login to EM console it tries to load the large amounts of instance and fault data from database leading to slowing up the EM console response time.

Solution:

Improving the Loading of Pages in Oracle Enterprise Manager Fusion Middleware Control Console

You can improve the loading of pages that display large amounts of instance and fault data in Oracle Enterprise Manager Fusion Middleware Control Console by setting two properties in the Display Data Counts section of the SOA Infrastructure Common Properties page.

These two properties enable you to perform the following:

• Disable the fetching of instance and fault count data to improve loading times for the following pages:
• Dashboard pages of the SOA Infrastructure, SOA composite applications, service engines, and service components
• Delete with Options: Instances dialog

• These settings disable the loading of all metrics information upon page load. For example, on the Dashboard page for the SOA Infrastructure, the values that typically appear in the Running and Total fields in the Recent Composite Instances section and the Instances column of the Deployed Composites section are replaced with links. When these values are large, it can take time to load this page and other pages with similar information.
• Specify a default time period that is used as part of the search criteria for retrieving recent instances and faults for display on the following pages:

• Dashboard pages and Instances pages of the SOA Infrastructure, SOA composite applications, service engines, and service components
• Dashboard pages of services and references
• Faults and Rejected Messages pages of the SOA Infrastructure, SOA composite applications, services, and references
• Faults pages of service engines and service components