Re: Remove DBMS_LOCK Locks

From: klabu <klabu_at_mailinator.com>
Date: Wed, 20 Jun 2007 15:41:52 -0400
Message-ID: <137j0ocn1g7f3@corp.supernews.com>

<sybrandb_at_hccnet.nl>
> From your post it is unclear how you are calling dbms_lock.release.
> You didn't type *litterally*
> exec dbms_lock.release(<lockid>);
> did you?
>
> --
> Sybrand Bakker
> Senior Oracle DBA

oh NO ! haha

this is the real spool here:

select * from sys.dbms_lock_allocated ;

NAME                                         LOCKID  EXPIRATION
----------------                ------------------   ----------------
REINSCHUNKING28            1073742457 18-Mar-2007
REINSCHUNKING301          1073742458 18-Mar-2007
REINSCHUNKING302          1073742459 18-Mar-2007
REINSCHUNKING303          1073742460 18-Mar-2007
REINSCHUNKING304          1073742461 18-Mar-2007
REINSCHUNKING305          1073742462 18-Mar-2007

<snip>

SQL> exec dbms_output.put_line(DBMS_LOCK.RELEASE(1073742457));

3

PL/SQL procedure successfully completed

SQL> exec dbms_output.put_line(DBMS_LOCK.RELEASE(1073742459));

3

PL/SQL procedure successfully completed Received on Wed Jun 20 2007 - 14:41:52 CDT