Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
Within an OLAP DML program, the SLEEP command suspends the program execution for at least the specified number of seconds.
Note:
SLEEP is rarely used in Oracle OLAP programs, because there is seldom a need to suspend program execution.SLEEP n
A numeric expression that specifies the number of seconds for Oracle OLAP to "sleep." Program execution is suspended for at least this number of seconds.
OLADM2773Example 10-125 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 statement, which suspends program execution for 10 seconds.
SLEEP 10