Re: preferred method to sleep()?
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 12 Nov 2008 09:13:20 GMT
Message-ID: <1226481198.733924@proxy.dienste.wien.at>
Date: 12 Nov 2008 09:13:20 GMT
Message-ID: <1226481198.733924@proxy.dienste.wien.at>
mh_at_pixar.com wrote:
> 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
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/toc.htm
The other ones are probably internal and not intended for public use, with the drawback that they may change without notice in new releases.
Yours,
Laurenz Albe
Received on Wed Nov 12 2008 - 03:13:20 CST