C1-TXNCU Feed Back Out Process Performance Issue
(Doc ID 2429229.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, DB - Database
C1-TXNCU, as part of the Feed Back Out Batch Set of Jobs, ran for 43 minutes. The actual job ran for 15 minutes. The rest of the time was spent initializing threads. During the run we identified the below query was stuck and all threads were stuck in PENDING status for a long time.
We observed the query only moved after we did a gather stats on CI_TXN_DTL_PRITM_STG table.
Any long term fix suggested for this issue ?
SELECT (SELECT MAX(BILLABLE_CHG_ID) FROM CI_TXN_DTL_PRITM_STG WHERE
BILLABLE_CHG_ID <> ' ' AND DO_NOT_AGG_SW = :1 AND TXN_HEADER_ID = :2
AND TXN_RATING_CRITERIA <> :3 ), (SELECT MAX(BILLABLE_CHG_ID) FROM
CI_TXN_DTL_PRITM WHERE BILLABLE_CHG_ID <> ' ' AND DO_NOT_AGG_SW = :4
AND TXN_HEADER_ID = :5 AND TXN_PRITM_STATUS_CD =:6 AND
TXN_RATING_CRITERIA <> :7 ) FROM DUAL
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