Sapurge With Lock In Multithread, Occasioning Performance Issue
(Doc ID 2951187.1)
Last updated on MAY 25, 2023
Applies to:
Oracle Retail Sales Audit - Version 16.0.3 and laterInformation in this document applies to any platform.
Goal
The sapurge when configured as multithread is locking between threads, occasioning performance issues.
Having analyzed using the command below, it was found one thread is running and all others are in blocking_session, waiting for this thread:
"delete FROM sa_balance_group sbg WHERE sbg . store_day_seq_no <= TO_NUMBER ( :b0 ) AND NOT EXISTS ( SELECT 1 FROM sa_tran_head sh WHERE sh . store_day_seq_no = sbg . store_day_seq_no )"
Solution
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
Goal |
Solution |