PolarDB-O 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-O is only partially implemented when compared to Oracle's version. PolarDB-O only supports DBMS_LOCK.SLEEP.

SLEEP

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

SLEEP(seconds NUMBER)

Parameters

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.