Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Remove DBMS_LOCK Locks

Remove DBMS_LOCK Locks

From: klabu <klabu_at_mailinator.com>
Date: Wed, 20 Jun 2007 15:01:23 -0400
Message-ID: <137iuc996mcn6f6@corp.supernews.com>


10gR2

there're many many records in "dbms_lock_allocated" from my previous testing, and I recognize the names
I know they're useless now

If they can/should be removed, how to do it ?

DBMS_LOCK.RELEASE(<lockid>) ;
returns " Parameter error"

SQL> desc sys.dbms_lock_allocated
Name Type Nullable Default Comments ---------- ------------- -------- ------- --------

NAME       VARCHAR2(128)
LOCKID     INTEGER       Y
EXPIRATION DATE          Y


thanks Received on Wed Jun 20 2007 - 14:01:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US