My Oracle Support Banner

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 later
Information in this document applies to any platform.


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 )"


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

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