DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - PL/SQL lock timer

PL/SQL lock timer

This event is called through the DBMSLOCK.SLEEP procedure or USERLOCK.SLEEP procedure. This event will most likely originate from procedures written by a user. Wait Time:

The wait time is in hundredths of seconds and is dependent on the user context.

Parameter

Description

duration

The duration that the user specified in the DBMS_LOCK.SLEEP or USER_LOCK.SLEEP procedures