Avg user wait time for task <task_ID>: <duration> ms, <number_of> waits, application pid <pid>
In a lock
collision, the wait time for a lock to be
released is quite considerable.
This can be caused
by a transaction that takes too long. Long wait times (task status
vwait) can also occur when various applications
want to lock the same object.
If the locks are requested by other sessions, the database system attempts to execute locking tasks with higher priority within the database kernel.
For information on
the current locks, see the system tables TRANSACTIONS and
LOCKS of
the database instance.
Check the following aspects of the application: