PolarDB for Oracle supports the DBMS_LOCK.SLEEP stored procedure.

Table 1. DBMS_LOCK stored procedures
Function/stored procedure Return type Description
SLEEP(seconds) N/A Pauses a session for the specified number of seconds.

The DBMS_LOCK package in PolarDB for Oracle is only partially implemented when compared to Oracle's version. PolarDB for Oracle only supports DBMS_LOCK.SLEEP.


The SLEEP stored procedure is used to pause the current session for the specified number of seconds.



Parameter Description
seconds Specifies the number of seconds for which the session is to be paused. You can specify a fractional value. For example, you can specify 1.75 to indicate one and three-fourths of a second.