Purge Staging Table Ongoing For 2 Hours + In NPRD
(Doc ID 3034129.1)
Last updated on JULY 16, 2024
Applies to:
Oracle Financial Services Crime and Compliance Management Transaction Monitoring Cloud Service - Version NA and laterInformation in this document applies to any platform.
Goal
Purge Staging Table ongoing for 2 hours + in NPRD due to DB fragmentation.
Batch purge was done multiple times due to data issue without any successful run of amldataload batch, hence data in tables got fragmented.
In General gather stats do defragmentation but product has gather stats at the end of Amldataload batch.
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 |