Locking problems

TIMEOUTS and DEADLOCKS, shown in the Locking Activity block of the Statistics trace report, should be close to zero.

If not, then if the number of LOCK REQUESTS is not significantly less than the total number of SQL DML requests, lock avoidance is not active. Set BIND CURRENT DATA to NO, declare the cursor with FOR UPDATE OF, and use the WHERE CURRENT OF cursor name with UPDATE and DELETE.