Re: preferred method to sleep()?
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Nov 2008 09:06:33 -0800
Message-ID: <1226509579.2014@bubbleator.drizzle.com>
>
> 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
Date: Wed, 12 Nov 2008 09:06:33 -0800
Message-ID: <1226509579.2014@bubbleator.drizzle.com>
Laurenz Albe wrote:
> 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
The one created specifically for end-users and end-user apps is USER_LOCK. It is not installed by default but requires the DBA run $ORACLE_HOME/rdbms/admin/userlock.sql.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Nov 12 2008 - 11:06:33 CST