sql

How to mass abort instances and reset your Oracle SOA BPEL environment?

Enterprise who usually run an Oracle SOA Suite BPEL environment to process workflows manage production and multiple test environments where they may need to mass abort instances. Especially to reset the Oracle SOA BPEL environment before running a non-regression or performance test. Below is the script I usually set up for my clients to close …

How to mass abort instances and reset your Oracle SOA BPEL environment? Read More »

How to monitor Oracle SOA BPEL purge?

Implementing a working Purge script to get rid of old Oracle SOA BPEL instances is one of the most important tasks to maintain a working Oracle SOA Suite environment in production. Forgetting to do so will have the whole environment slow down as Oracle SOA Bpel database get bigger. Depending on your business requirement, I …

How to monitor Oracle SOA BPEL purge? Read More »

How to partition for performance your Oracle SOA BPEL Database?

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 …

How to partition for performance your Oracle SOA BPEL Database? Read More »

Useful SQL queries for monitoring Oracle SOA BPEL

If you run Oracle SOA BPEL on-premise and at scale, you know how easier it can be to monitor your SOA BPEL processes through SQL queries. Those SQL queries get more profitable the more SOA BPEL instances you get, as the Enterprise Manager console usually doesn’t work for big payloads. You’ll find below a couple …

Useful SQL queries for monitoring Oracle SOA BPEL Read More »

Scroll to Top