Hi.
The DBMS_LOCK.sleep() function accepts fractions of a second also, like:
SQL> SET TIMING ON
SQL> EXEC DBMS_LOCK.sleep(0.01);
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.03
SQL>
Remember, there is some time overhead associated with calling the procedure etc.
Cheers
Tim...




Reply With Quote