SA_PURGE_JOB Is Long Running In Hourly Cycles
(Doc ID 2979883.1)
Last updated on OCTOBER 11, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
SA_PURGE_JOB is long Running in hourly cycles
Oracle has provided hot fix 19.3.006.19 in BugId: 35553148, which deployed on 21-SEP-2023. This fix was supposed to solve the long running issue of SA_PURGE_JOB. But since then we have noticed the sa_puge hourly job is running long.
EXPECTED BEHAVIOR
-----------------------
SA_PURGE_JOB to be run in expected time.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Trigger the sa_purge_job
2. Monitor performance of Job.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete Job in expected time.
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 |