Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Remove DBMS_LOCK Locks
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