1. PL/SQL Packages Reference
  2. DBMS_LOCK

3 DBMS_LOCK

The DBMS_LOCK package provides an interface to Lock Management services. 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.

DBMS_LOCK Subprograms

TimesTen supports only the SLEEP subprogram. Table 3-1 summarizes that subprogram, followed by a full description.

Table 3-1 DBMS_LOCK Package Subprograms

Subprogram Description

SLEEP Procedure

Suspends the session for a specified duration.

SLEEP Procedure

This procedure suspends the session for a specified duration.

Syntax

DBMS_LOCK.SLEEP (
   seconds  IN NUMBER);

Parameters

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 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 in Oracle TimesTen In-Memory Database PL/SQL Developer's Guide for information about PLSQL_TIMEOUT.

Examples

DBMS_LOCK.SLEEP(1.95);