My Oracle Support Banner

Data performance issue on list data in TF (Doc ID 2789085.1)

Last updated on JULY 07, 2021

Applies to:

Oracle Financial Services Transaction Filtering - Version 8.0.8.1.0 and later
Information in this document applies to any platform.

Symptoms

User want to create an index on FSI_RT_LIST_DATA table since its taking huge time if it contains more than 6 M records in it.

Same way they need for FSI_RT_LIST_DATA_STG and FSI_RT_LIST_DATA_PROCESSED tables.

Steps to reproduce:

Step 1 : Load 6M records in EDQ

Step 2 : Execute the Job under watchlist management 

Step 3 : Check for the performance.

Expected result:

User expecting less time for data load.

Actual result:

Performance issue occurs and user want to generate an index on below tables.

FSI_RT_LIST_DATA, FSI_RT_LIST_DATA_STG and FSI_RT_LIST_DATA_PROCESSED tables.

Issue Encountered :

Performance impacted to load the data into tables.

Changes

6Million records of data has been loaded into edq system.

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!


In this Document
Symptoms
Changes
Cause
Solution


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