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