SLEEP procedure

Amount of time, in seconds, to suspend the session. 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 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.