O'Reilly logo

Oracle SOA Suite Performance Tuning Cookbook by Matt Brasier, Nicholas Wright

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Purging data from the BPEL store

In this recipe we will remove old BPEL dehydration data and state from the SOA infrastructure database.

Getting ready

You will need to have access to the database on which the SOA_INFRA schema is hosted. In this recipe, we'll be using a command line local to the host on which we installed the database.

You'll also need access to the SQL scripts bundled with SOA Suite. If you have SOA Suite installed on the host running the database, you can find them under MW_HOME/SOA_ORACLE_HOME/rcu/integration/soainfra/sql/soa_purge.

If the database is running on a separate host, you can simply copy the soa_purge directory from the WebLogic administration server to a directory on the database host; we'll be using e:\soa_purge for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required