My Oracle Support Banner

pin_inv_accts Performance Issue (Doc ID 2788335.1)

Last updated on JULY 05, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Customer have initiated invoicing(pin_inv_accts) for 100K accounts and captured the stats for 50K and stopped the Invoicing as performance with 9.46 Transaction Per Second(TPS) .

Start time of the script(pin_inv_accts) for 100k accounts : Fri Apr 30 22:02:00 JST 2021
End time of the script while completing 50K accounts      : Fri Apr 30 23:28:05 JST 2021

After Enabling the stack for 5k accounts:
start time : Fri Apr 30 23:37:23 JST 2021
End Time : Fri Apr 30 23:45:35 JST 2021

In both the cases achieved around 10 TPS.

STEPS: 
Followings are the additional three test cases executed (ran pin_inv_accts)
Customer have disabled the customization from cm pin.conf and performed the Invoicing with Different threads and below is the observation

1) With 50- threads for 50k account, getting PIN_ERR_DM_CONNECT_FAILED error and achieved around 80 TPS with out of the box(OOB)  code.

cm pin.conf  :

- fm_inv inv_event_fetch_size 15000
- fm_inv inv_item_fetch_size  50000
- fm_inv inv_perf_features 0x00000010
- cm cm_cache_space 1073741824  
dm_oracle pin.conf
- dm dm_n_fe 16
- dm dm_bigsize 6442450944
- dm dm_max_per_fe 40
- dm dm_n_be 256
- dm dm_shmsize 15032385536  
- dm dm_trans_be_max 235

- dm extra_search 1     

1.pin_inv pin.conf :

1) With 50- threads for 50k account , getting DM_CONNECT_FAILED  and achieved around 80 TPS with OOB code 

- pin_mta children 50
- pin_mta per_batch 2000
- pin_mta per_step 10000
- pin_mta fetch_size 100000

2) With Children 20 Thread for 50k account, getting PIN_ERR_DM_CONNECT_FAILED. We achieved around 80 TPS with OOB code.
- pin_mta children 20
- pin_mta per_batch 500
- pin_mta per_step 10000
- pin_mta fetch_size 100000

3)With Children 10 Thread for 50k account. achieved around 50 TPS with OOB code.
- pin_mta children 10
- pin_mta per_batch 500
- pin_mta per_step 10000
- pin_mta fetch_size 100000

Customer did not achieve expectation with the minimal threads. T





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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.