My Oracle Support Banner

What is the impact of Dropping SRT Transaction Tables In SARM to Improve Performance? (Doc ID 1587703.1)

Last updated on JULY 04, 2023

Applies to:

Oracle Communications ASAP - Version 7.0.2 and later
Information in this document applies to any platform.


This note provides a  response to a query regarding the dropping of SRT transaction tables in SARM.

There is huge amount of data in following SARM tables that is causing slow order processing.


The plan is drop and recreate the tables. These 3 tables do not seem to be referred by any OCA procedure. In summary, after dropping , the usershould be able to view orders in OCA without any issues.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.