Quick Search:
Oracle PL/SQL Code Library
Find Or Post Oracle Jobs
Oracle Discussion & Chat
 Oracle PL/SQL: Display and release DBMS_LOCK locks Jump to:  
Category: >> Oracle PL/SQL >> Display and release DBMS_LOCK locks Bookmark and Share

<< 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 Varia...
» 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;

Oracle Magazine
and Oracle White Papers

SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 31 users online    © 2009 psoug.org

Forgot your password?