OWSM MDS Partition Holding A Large Number Of Data Into MDS Schema (Doc ID 1519531.1)

Last updated on MARCH 30, 2016

Applies to:

Oracle Web Services Manager - Version 11.1.1.1 to 11.1.1.6.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

In attempt to upgrade from 11.1.1.3 to 11.1.1.5, there is a performance issue caused by the growing amount of data in the MDS repository.

There appears to be no script provided for OWSM to purge data from the repository.  According to the documentation, no configuration is needed for OWSM since it is supposed to be purged automatically.  However, there is no way to determine if automatic purging is occurring or not.

There is a need for a script to purge unused OWSM data.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms