DBMS_LOCK

The DBMS_LOCK package provides an interface to lock-management services. In the current release, TimesTen supports only the sleep feature.

Table 7-2 describes the supported DBMS_LOCK subprogram.

Table 7-2 DBMS_LOCK Subprograms

Subprogram Description

Subprogram	Description
`SLEEP` procedure	This procedure suspends the session for a given duration. Specify the amount of time in seconds. The smallest supported increment is a hundredth of a second. For example: DBMS_LOCK.SLEEP(1.95); Notes: The actual sleep time may be somewhat longer than specified, depending on system activity. If `PLSQL_TIMEOUT` is set to a positive value that is less than this sleep time, the timeout takes effect first. Be sure that either the sleep value is less than the timeout value, or `PLSQL_TIMEOUT=0` (no timeout). See PL/SQL Connection Attributes for information about `PLSQL_TIMEOUT`.

SLEEP procedure

This procedure suspends the session for a given duration. Specify the amount of time in seconds. The smallest supported increment is a hundredth of a second. For example:

DBMS_LOCK.SLEEP(1.95);

Notes:

The actual sleep time may be somewhat longer than specified, depending on system activity.
If PLSQL_TIMEOUT is set to a positive value that is less than this sleep time, the timeout takes effect first. Be sure that either the sleep value is less than the timeout value, or PLSQL_TIMEOUT=0 (no timeout). See PL/SQL Connection Attributes for information about PLSQL_TIMEOUT.