SOA purge activity

3231400

Hi

We are conducting SOA purge activity to delete instances from SOAINFRA tables.

As per the oracle documentation, to improve the performance of purging activity, indexes may or may not be needed to create.

But if required, can anyone let us know what all are the tables that needs to be indexed.

Also on support one of the document says Doc ID 1341299.1

"We have seen that in some cases, due to the large amount of data being deleted from SOAINFRA schema, there is some performance degradation on SOA runtime processing.

We advise customers, which observe such behavior, to update Table Statistics and perform an Index Rebuild in order to recover performance. "

Can anyone let us know exact if any specific table stats and indexes that needs to be rebuild here.

Any help is appreciated.

Thanks in advance,

951803

What version of SOA

3231400

11.1.1.7.8