My Oracle Support Banner

C1-TXCNC Performance Issue (Doc ID 2431219.1)

Last updated on AUGUST 08, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.5.0.3.0 version, DB - Database

C1-TXCNC Performance Issue

C1-TXCNC job ran for 23 minutes in Parallel Production and we observed that the below query took the longest time. From the AWR it seems this query took 12 minutes to complete which happens in the thread initialization.

Findings :
• Query is taking a longer time to go over the partitions to get the High and Low TXN IDs.
• Why is it that the user cannot have the same approach of getting the Partitions first based on the TXN Headers and then find the High and Low Id?



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!


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