My Oracle Support Banner

Service Request Purge Concurrent Program Has Performance Issues Deleting Charges Lines (Doc ID 1351345.1)

Last updated on DECEMBER 09, 2020

Applies to:

Oracle Teleservice - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.4 version, 'Service Request Data Purge'

Actual Behavior

The 'Service Request Data Purge' concurrent shows bad performance when deleting charges lines.

Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. From the Service responsibility start the 'Service Request Data Purge'
2. It takes too much time to complete.
3. When looking at a TKPROF the following statement is the one that is taking most of the time to complete:

DELETE /*+ index(e) */ CS_ESTIMATE_DETAILS E
WHERE
INCIDENT_ID IN ( SELECT /*+ no_unnest no_semijoin cardinality(10) */
 OBJECT_ID FROM JTF_OBJECT_PURGE_PARAM_TMP WHERE PROCESSING_SET_ID = :B1 AND
 OBJECT_TYPE = 'SR' AND NVL(PURGE_STATUS, 'S') = 'S' )

Changes

 

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
References


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