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.
On : 12.0.4 version, 'Service Request Data Purge'
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
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' )
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