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
Dony,

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.

Report message to a moderator

Previous Topic: Re: explain plan
Next Topic: Re: serial columns in oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 03 12:03:17 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.