Locks in NRIV Table
I am new to production support while monitoring the data loads BASIS find the locks in BW system.
We got more alerts for Row lock contention IN BW production .Kindly help me understanding and resolving the issue.
SELECT /*+ FIRST_ROWS (1) */ "FROMNUMBER", "TONUMBER", "NRLEVEL" FROM "NRIV" WHERE "CLIENT"=:A0 AND "OBJECT"=:A1 AND "SUBOBJECT"=:A2 AND "NRRANGENR"=:A3 AND "TOYEAR"=:A4 FOR UPDATE
please suggest the solution to avoid the above locks.