Purging old instance data from SOA/BPM 11g

When you are running a lot of instances of your composites through SOA/BPM 11g in your testing/development environment, you will start to fill up the available space in your database with the logging and auditing information for these instances.  From time to time, you will want to clean up your database by purging the old instance data.

Starting from version 11.1.1.2, we provide a set of SQL scripts in the following location that can be used for just this purpose.

<MIDDLEWARE_HOME>\Oracle_SOA1\rcu\integration\soainfra\sql\purge

If you want to get a feeling for how much free space you have, you might like to use the query in this post, which will produce results like those shown below.

If you are running an earlier version, you can download the scripts as a patch by looking up Oracle Support document number 815896.1.  This document also provides details about how to define a filter so that the scripts will only remove certain instance data, and leave other data untouched.

To remove all old instance data, you can just invoke the scripts like this:

sqlplus dev_soainfra/welcome1 @purge_soainfra_oracle.sql

About Mark Nelson

Mark Nelson is an Architect (an "IC6") in the Fusion Middleware Central Development Team at Oracle. Mark's job is to make Fusion Middleware easy to use in the cloud and at home, for developers and operations folks, with special focus on continuous delivery, configuration management and provisioning - making it simple to manage the configuration of complex environments and applications built with Oracle Database, Fusion Middleware and Fusion Applications, on-premise and in the cloud. Before joining this team, Mark was a senior member of the A-Team since 2010, and worked in Sales Consulting at Oracle since 2006 and various roles at IBM since 1994.
This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s