My Oracle Support Banner

Deal Purchase Time Increases Exponentially With Number Of Purchases (Doc ID 3016185.1)

Last updated on APRIL 19, 2024

Applies to:

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

Goal

In Oracle Communications Billing and Revenue Management (BRM) the PCM_OP_SUBSCRIPTION_PURCHASE_DEAL opcode purchases a deal for a specified account or service, the products and discounts in the deal are purchased for the account or service object specified in the input flist.

When customizing a wrapper which calls PCM_OP_SUBSCRIPTION_PURCHASE_DEAL in a loop for each deal, it was observed that the purchase performance increase till a certain number of deals. After that the performance goes exponentially worse.


Here is an example of the performance over time, we can that observe that  . As you can see if the number of deals purchased is around 500, the performance is good, after that it is bad.

1 deal - 1605ms - 1605ms/txn
10 deals - 3885ms - 388ms/txn
100 deals - 28785ms - 287ms/txn
500 deals - 99000ms - 198ms/txn
1000 deals - 508975ms - 508ms/txn
5500 deals - 3hr51min - 2520ms/txn


 

Solution

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
Goal
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.