Last updated on JUNE 11, 2010
Applies to:
Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0Information in this document applies to any platform.
Goal
During billing of accounts, the same search is called 2 times, with exactlythe same parameters:
Below is the search from cm pinlog:
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service 1, /balance_group 2 where 1.F1 = V1 and 1.F2 = 2.F3 and 2.F4 = V4 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 228799169 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_BAL_GRP_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 228802241 68
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 8
1 PIN_FLD_POID POID [0] NULL poid pointer
1 PIN_FLD_BAL_GRP_OBJ POID [0] NULL poid pointer
1 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
1 PIN_FLD_SUBSCRIPTION_OBJ POID [0] NULL poid pointer
1 PIN_FLD_STATUS ENUM [0] 0
1 PIN_FLD_LAST_STATUS_T TSTAMP [0] (0) <null>
1 PIN_FLD_NEXT_ITEM_POID_LIST STR [0] NULL str ptr
1 PIN_FLD_ITEM_POID_LIST STR [0] NULL str ptr
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service 1, /balance_group 2 where 1.F1 = V1 and 1.F2 = 2.F3 and 2.F4 = V4 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 228799169 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_BAL_GRP_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 228802241 68
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 8
1 PIN_FLD_POID POID [0] NULL poid pointer
1 PIN_FLD_BAL_GRP_OBJ POID [0] NULL poid pointer
1 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
1 PIN_FLD_SUBSCRIPTION_OBJ POID [0] NULL poid pointer
1 PIN_FLD_STATUS ENUM [0] 0
1 PIN_FLD_LAST_STATUS_T TSTAMP [0] (0) <null>
1 PIN_FLD_NEXT_ITEM_POID_LIST STR [0] NULL str ptr
1 PIN_FLD_ITEM_POID_LIST STR [0] NULL str ptr
These 2 searches retrieve the same set of services for the account. In some environments , this might result in performance issue. A general recommendation could be to keep the first search, cache it and re-use it later when services are needed.
Solution
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