Within an OLAP DML program, the SLEEP command suspends the program execution for at least the specified number of seconds.
SLEEP is rarely used in Oracle OLAP programs, because there is seldom a need to suspend program execution.
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.
Example 10-124 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.