Delete From Sa_bank_ach Not Thread Specific For Sapurge Job
(Doc ID 2819838.1)
Last updated on NOVEMBER 08, 2021
Applies to:Oracle Retail Sales Audit - Version 16.0.3 and later
Information in this document applies to any platform.
Delete from sa_bank_ach not Thread Specific for sapurge job.
Steps To Recreate:
1) Multi-thread sapurge.
2) Run sapurge
3) Notice all threads run the DELETE FROM sa_bank_ach statement and notice contention, as there is no different between DELETE statement for each thread
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