Oracle SOA Suite 11g - Purging Metadata Version History for SOA-INFRA

Oracle SOA Suite 11g - Purging Metadata Version History for SOA-INFRA:

For database-based MDS repositories, you can purge the metadata version history from a partition. (File-based MDS repositories do not maintain version history.) This operation purges version history of unlabeled documents from the application's repository partition. The tip version (the latest version) is not purged, even if it is unlabeled.

To purge labeled documents, you must first delete the label.

Consider purging metadata version history on a regular basis as part of MDS Repository maintenance, when you suspect that the database is running out of space or performance is becoming slower. This operation may be performance intensive, so plan to do it in a maintenance window or when the system is not busy.

To use WLST to purge metadata version history, use the purgeMetadata command. You specify the documents to be purged by using the older than parameter, specifying the number of seconds.

The following example purges all documents older than 100 seconds:

wls:/offline> connect ()

Please enter your username: weblogic

Please enter your password:

Please enter your server URL [t3://localhost:7001] :t3://soahost:soaport

Connecting to t3://nft-soa-vip1:8004 with userid weblogic...

Successfully connected to managed Server 'SOA1' that belongs to domain 'SOACoreDomain'.

wls:/SOACoreDomain/serverConfig> purgeMetadata(application='soa-infra', server='SOA1', olderThan=100)

Executing operation: purgeMetadata.

Metadata purged:Total number of versions: 3925.

Number of versions purged: 0.

wls:/SOACoreDomain/serverConfig>

To use Fusion Middleware Control to purge the metadata version history:

1. From the navigation pane, expand the farm, expand SOA and then right click on soa-infra.
2. From the menu, choose Administration then choose MDS Configuration.

The MDS Configuration page is displayed.

1. Click Purge.

The Purge dialog box is displayed, as shown in the following figure:

1. In the Purge all unlabeled past versions that are older than field, enter a number and select the unit of time. For example, enter 3 and select months.
2. Click OK.

A progress box is displayed. When the operation completes, a completion box is displayed.

3. Click Close.