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 :
- Implementing the right database purge strategy
- Monitor large instances to improve your composite performances (see https://cedricleruth.com/useful-monitoring-sql-queries-for-oracle-soa-bpel/)
- Implement the proper Oracle Database partitioning
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.