SLEEP

Within an OLAP DML program, the SLEEP command suspends the operation of Oracle OLAP for at least the specified number of seconds.

Syntax

SLEEP n

Arguments

n: A numeric expression that specifies the number of seconds for Oracle OLAP to "sleep." Program execution will be suspended for at least this number of seconds.

Notes

SLEEP Rarely Used

SLEEP is rarely used in Oracle OLAP programs, because there is seldom a need to suspend program execution.

Examples

Example 21-37 Suspending Program Execution

In a program, suppose you execute a statement that might take 10 seconds to complete. You can follow that statement with this SLEEP command, which suspends program execution for 10 seconds.

SLEEP 10