Quick Search:
 Oracle PL/SQL: Display and release DBMS_LOCK locks Jump to:  
Category: >> Oracle PL/SQL >> Display and release DBMS_LOCK locks  

<< lastnext >>

Snippet Name: Display and release DBMS_LOCK locks

Description: Release DBMS_LOCK locks on database.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» LOCKS: View Locked Objects
» LOCKS: Table Locking
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Anonymous blocks: Constants and Variab...
» Anonymous blocks: Sample Code
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 02nd, 2009

SET serveroutput ON size 50000
col name format a30
SET veri off feed off pagesize 50000
cle scr
prompt Please enter the USER's login id:
select *
from   sys.dbms_lock_allocated
where  upper(name) like upper('%&userid.%');
prompt Please enter lockid to release:
        rc integer;
        rc := dbms_lock.release('&lockid');
        if rc = 0 then
        elsif rc = 3 then
                dbms_output.put_line('Parameter Error.');
        elsif rc = 4 then
                dbms_output.put_line('DO NOT own LOCK specified.');
        elsif rc = 5 then
                dbms_output.put_line('Illegal LOCK handled.');
                dbms_output.put_line('Unknown error.');
        end if;

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org