Home » RDBMS Server » Server Administration » Re: DBMS_lock.SLEEP
Re: DBMS_lock.SLEEP [message #370213] Mon, 16 November 1998 14:59
Bill Hoffman
Messages: 2
Registered: November 1998
Junior Member

DBMS_LOCK.SLEEP suspends the current session for a specified number of seconds.

In our system, transactions are posted in tables that we refer to as queues. The program queries the queue for transaction, if found, they are processed. If no transactions are found they program will sleep for a few seconds and do it all over again.
Previous Topic: Re: explain plan
Next Topic: Re: serial columns in oracle
Goto Forum:

Current Time: Sun Nov 27 19:13:44 CST 2022