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>


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

Original text of this message