DBMS_SESSION.SLEEP Oracle Database 18C

In Oracle Database 18C very popular popular procedure DBMS_LOCK.SLEEP is also available in package DBMS_SESSION.

The procedure suspends session for specified number of seconds(fractions can be used)

set timing on
BEGIN
DBMS_SESSION.SLEEP(2.33);
END;
/

Elapsed: 00:00:02.335

Procedure DBMS_LOCK.SLEEP is now obsolete however still available in 18C for backward compatibility. You need to think about upgrade code.

Have a fun 🙂

Tomasz

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.