
Oracle SOA Suite 11g Performance Tuning Cookbook

In this recipe we will remove old BPEL dehydration data and state from the SOA infrastructure database.
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 this purpose.
Follow these steps to run the soa_purge
scripts:
First, log in to sqlplus
as a user with sysdba
privileges, and grant the following permissions to the dev_soainfra
user, then exit the shell:
sqlplus / as sysdba SQL> GRANT...