Re: preferred method to sleep()?
Date: 12 Nov 2008 09:13:20 GMT
> I see four methods to sleep:
> * dbms_backup_restore
> * dbms_drs
> * dbms_lock
> * user_lock
> Are any of them preferrable, deprecated, recommended, etc?
Just from looking at the Oracle 11.1 documentation, I would recommend
DBMS_LOCK.SLEEP, since DBMS_LOCK is the only package in your list
that is described in
The other ones are probably internal and not intended for public use, with the drawback that they may change without notice in new releases.
Laurenz Albe Received on Wed Nov 12 2008 - 03:13:20 CST