Oracle Application Server

Response time is basically sum of process time and wait time. All process spend most of their time waiting for a resources to get released. Resources such as memory, database-connections, etc. To improve performance, we should reduce the overall wait time. One primary resource is database connections. One way to reuse and manage database connections is to use the JNDI and connections pools properly. Connection Pools are connections that are reserved by the application server to a database and thereby reduces the time to wait for a new connections to be made to the database. One good practice to ensure that you always use the jndi is, when you use a database adapter in your BPEL do not enter the database connection information in the WSDL (apart from your jndi name). If you enter the database connection information and your jndi information, it will default to the connection parameters if your jndi is invalid. You should also manage the Database Connection Timeouts and inactivity connection timeout to manage the database connections in the connection pool.

Another thing to do would be to increase Java Heap and PermGen Space for the OC4J instance. This increases the overall resources avaliable to the JVM process. In oracle application server, you can have multiple OC4J instances. Unless you have a strong reason to put all your processes in the same instance, it is a good practice to have your processes spread-out over multiple instances. Each OC4J instances has its own set of resources (connection pools, heap, httpd connections, perm gen space…). Breaking them apart will improve the overall performance of your SOA environment.

Oracle BPEL Console

From the BPEL Console side, there are a few settings that can be done to keep the dehydration store clean. For a production environment, typically you should just hold the log level to ‘ERROR’. This makes the production logs more usable and clean from everyday event logs. BPEL Console also keeps the audit trail of all the events of every bpel. This is not necessary in a production environment, keeping the audit trail to ‘production’ is enough. Increasing the ‘BPELServerDataSource’ (connection pool to dehydration store) connection pool would also make a positive different in its performance.

This blog just outlines some of the changes that can be done in Oracle SOA Environment to increase your overall SOA system performance. We’ll be happy to help review and make these actual changes.

Related Information:

1. Complete Fusion Middleware 11g environment setup

   We have recently been working on and completed an entire Oracle Fusion Middleware 11g environment setup for a customer: Identity...

2. Conditionally Purge BPEL Instances on 10.1.3.x

   Marc Kelderman wrote a helpful article on this topic: http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html One of the users there notes: Note there is a...

3. Oracle AS: Undeploying Multiple Applications (including BPEL Human Tasks)

   Undeploying a single application in Oracle Application Server is pretty straightforward. However, I had a scenario where I needed to...

4. Oracle Application Server Startup and Shutdown Script Generator - FREE

   Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment....

5. Oracle BPEL - Wait Activity Stuck or Hanging - Never Returns to Console

   This is a very, very common complaint I hear from Oracle BPEL developers, testers, and production support. I find there...

6. JDeveloper Freezing - Optimize Performance for Large BPEL Flows

   I was running into issues with my Jdev being inadequately slow, hanging, or freezing when working with large BPEL process...

7. Discoverer - Public Connections for Oracle Applications with SSO

   While using SSO, in order to create a public connection to Oracle Discoverer for Oracle Applications, I suggest creating a...

8. Performance Evaluations Are In

   M&S Consulting recently participated in an independent performance review. The survey was created, administered, and scored by an independent third...