My Oracle Support Banner

Migrated Data Deletion After AMM Execution Is Very Slow (Doc ID 1572996.1)

Last updated on DECEMBER 08, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.