AMM Took Around 23 to 25 Minutes for 1 Account (Doc ID 2045566.1)

Last updated on JULY 27, 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

On : 7.5.0.8.0 version, Account Migration Manager

In Pre-Production environment, account migration took nearly 23 to 25 minutes, which was not acceptable.

In Dev env, it took only 15 seconds for the same account.


ACTUAL BEHAVIOR
---------------
AMM took around 23 to 25 minutes for 1 account.


EXPECTED BEHAVIOR
-----------------------
AMM should take the similar timing as seen in Dev env.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Below mentioned are details we got during the AMM testing
1. Testing account migration from primary schema (schema-1) to secondary schema (schema-2)
2. Job submitted for a single account which was created one month back. [Having very few items and events] [ pre-provisioned account- account which doesn't have an invoice.] This account successfully migrated without any error. but it takes 23 to 25 mints
3. All the configuration required for AMM have done as mentioned in the BRM documentation.
4. With the same configuration we were able to move accounts in Development environment (in less than 15 seconds)
5. Initially in Pre-PROD environment AMM was running for more than 5 hrs.
Running time came done to 2.69 hrs after creating few table indexes and gather stats
Gather stats on AU_PURCHASED_PRODUCT_CYCLE_F_T and GROUP_T;
Index created on non unique account_obj_id0 on batch_t, proc_aud_t, amt_base_detail_t, invoice_t, XWORLDS_BATCH_ARCHIVE_EVENTS_T
7. Created few more index later like below and followed the steps Doc ID 1334288.1, it reduced to 23 to 25 mints

create index i__xx_proc_acc_poid on PROC_AUD_T(account_obj_id0)
pctfree 10
Tablespace PIN07X
compute statistics
parallel 10 nologging;

create index i__xx_unq_acc_poid on unique_acct_no_t(account_obj_id0)
pctfree 10
Tablespace PIN07X
compute statistics
parallel 10 nologging;

create index i__xx_au_ordbg_acc_poid on au_ordered_balgroup_t(account_obj_id0)
pctfree 10
Tablespace PIN07X
compute statistics
parallel 10 nologging;

create index i__xx_inv_acc_poid on invoice_t(account_obj_id0)
pctfree 10
Tablespace PIN07X
compute statistics
parallel 10 nologging;

create index i__xx_xworlds_evts_acc_poid on XWORLDS_BATCH_ARCHIVE_EVENTS


Changes

 

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