Migrated Data Deletion After AMM Execution Is Very Slow
Last updated on DECEMBER 08, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 7.5.0]
Information in this document applies to any platform.
Account Migration from Schema1 to Schema2 is executed for 100 Accounts. After the successful migration, the migrated Accounts are deleted from the Source schema (schema1) using the below command:
pin_amt –d job_id
As per the test:
- For 100 Accounts Migration it took 20 Minutes.
- For deleting the migrated data for 100 accounts, it took 60 Minutes.
If 1000 Accounts have to be migrated in a day, in order to purge/delete the same from schema, it may take 10 Hours which is a lot of time and may be unacceptable.
The performance needs to be improved.
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