My Oracle Support Banner

Insert And Delete KDD_PERSON_MASTER Data Taking Time Due To Millions Of Records Of One Person ID (Doc ID 2934103.1)

Last updated on MARCH 15, 2023

Applies to:

Currency Transaction Reporting - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Prod job is taking 30 hours and still running. In KDD_PERSON_MASTER data, there are total records as "33805855" where as one Conductor ID ('XYZ') alone having "33554435" records.
Due to this, insert and delete is running 33 million of time and approximately insert and delete is taking 10 hours run.

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
Cause
Solution
References


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