Avg user wait time for task 

Avg user wait time for task <task_ID>: <duration> ms, <number of> waits, application pid <pid>

Explanation

In a lock collision, the wait for a lock to be released is very long.

This can be caused by a long transaction. Long wait times (task state vwait) can also occur when many applications want to lock the same object.

The database system attempts to execute locking tasks with high priority within the database kernel if the locks are requested by other sessions.

For information on the current locks, see the system tables TRANSACTIONS and LOCKS in the database instance.

User Response

Check the following aspects of the application:

• Is it suitable for isolation level 0 (uncommitted)?
• Can the time between the lock request and the COMMIT statement be reduced?
• Can you avoid simultaneous locks on the same row by splitting tables?