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 is suspended for at least this number of seconds.
Example 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.