Oracle SOA BPEL infrastructures are notoriously hard to scale. Once your production Oracle SOA BPEL Database grows, you’ll often find that your whole Oracle SOA BPEL infrastructure performance may hinder. To fix it, you then need to focus on :

How to partition for performance your Oracle SOA BPEL Database?

Below is an example of partitioning scripts written after helping two of my clients running an Oracle SOA BPEL 11g Infrastructure. This script is provided “as is” without warranty of any kind. Do not use this directly in your production environment. Please read it, test it, and update it to fit your specific instances.

Was this post helpful?