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 laterInformation in this document applies to any platform.
Goal
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.
tbl_srt_ctx
tbl_srt_correlation
tbl_info_parm
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.
Solution
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
Goal |
Solution |
References |