PolarDB for Oracle supports the DBMS_LOCK.SLEEP stored procedure.
|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.
|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.|