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

Last updated on AUGUST 08, 2013

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.

Cause

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