3 DBMS_LOCK

The DBMS_LOCK package provides an interface to Lock Management services.

In the current release, TimesTen supports only the SLEEP subprogram.

This chapter contains the following topics:

Using DBMS_LOCK

TimesTen currently implements only the SLEEP subprogram, used to suspend the session for a specified duration.

In the current release, TimesTen supports only the SLEEP subprogram.

TTPLP66770 Table 3-1 DBMS_LOCK package subprograms

Subprogram	Description
SLEEP procedure	Suspends the session for a specified duration.

This procedure suspends the session for a specified duration.

Syntax

DBMS_LOCK.SLEEP (
   seconds  IN NUMBER);

Parameters

TTPLP66783 Table 3-2 SLEEP procedure parameters

Parameter	Description
`seconds`	Amount of time, in seconds, to suspend the session, where the smallest increment is a hundredth of a second

Usage notes

The actual sleep time may be somewhat longer than specified, depending on system activity.
If the PLSQL_TIMEOUT general connection attribute is set to a positive value that is less than this sleep time, the timeout will take 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" in Oracle TimesTen In-Memory Database PL/SQL Developer's Guide for information about PLSQL_TIMEOUT.

Examples

DBMS_LOCK.SLEEP(1.95);