My Oracle Support Banner

Performance Issues With Multi-edq 4 Threads for sanctions (Doc ID 2905310.1)

Last updated on NOVEMBER 01, 2022

Applies to:

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

Symptoms

Steps to reproduce :

Step 1 : Configure multi edq for CS

Step 2 : Execute CS batch 

Step 3 : Check the performance of batch execution.

Expected result :

Batch must be completed without issue for multiple edq configuration.

Issue Encountered :

User encountered below error while running the cs batch

ORA-04021: timeout occurred while waiting to lock object EDQ22_EDQRESULTS.DN_T199. (Code: 200,302) (Code: 209,861)

A four Multi-EDQ batch has been executed 20.09.2022 EDQs running in parallel in Multi-EDQ Mode. three has finished KO (0022) with ORA-04021.

Changes

Multi edq configured with single DB

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.