Billing and Revenue Management (MOSC)

MOSC Banner

Tips for Performance Improvements on CustomerSearch Module

edited Nov 27, 2017 4:02AM in Billing and Revenue Management (MOSC) 6 commentsAnswered

Hi Experts,

We are working on performance enhancements for rating Pipeline. On enabling the instrumentation (kill -s USR1 <pid>), it seems that the most amount of time is consumed by CustomerSearch module.

Below is the snapshot of the pipeline logs related to CustomerSearch :

DB:AccountProcessingTime_14, 1167645

DB:AccountProfileUpdateProcessingTime_14, 973

DB:AccountProfileUpdateQuery_BulkReadTime_14, 754972

DB:AccountQuery_BulkReadTime_14, 1165745

DB:PurchasedDiscountUpdate_10, 350164

DB:PurchasedProductUpdate_3, 209182

DB:ServiceOrderedBalanceGroupProcessingTime_1, 77590

DB:ServiceProcessingTime_2, 204840

DB:ServiceProfileUpdateProcessingTime_2, 269

DB:ServiceProfileUpdateQuery_BulkReadTime_2, 154015

DB:ServiceQuery_BulkReadTime_2, 204674

FT:CustomerASearch_70, 1898728

FT:CustomerBSearch_70, 1148630

FT:EdrSetDate_70, 267

FT:EdrSetup_70, 678

Q1. Are the functions starting with DB: related to data processing from database ?

Q2. Are the functions starting with FT: related to in memory data processing ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center