Oracle object unlock - 表，包，过程，函数

来源：互联网发布：淘宝购买点卡交易关闭编辑：程序博客网时间：2024/06/06 08:43

Oracle 对象解锁-表，包，过程，函数

表解锁 v$locked_object
V$LOCKED_OBJECT lists all locks acquired by every transaction on the system. It shows which sessions are holding DML locks (that is, TM-type enqueues) on what objects and in what mode.

select p.spid,         a.serial#,          c.object_name,         b.session_id,         b.oracle_username,         b.os_user_name   from   v$process p,v$session a, v$locked_object b,all_objects c   where  p.addr=a.paddr and          a.process=b.process and          c.object_id=b.object_id

找到sid,serial#将涉及的session杀掉
alter system kill session 'sid,serial#';

包，过程，函数解锁dba_ddl_locks
DBA_DDL_LOCKS lists all DDL locks held in the database and all outstanding requests for a DDL lock.
包，过程，函数等被锁定，可以通过该视图进行定位于解锁。

col OWNER for a30col NAME for a30Select b.SID,b.SERIAL#,a.OWNER,a.NAME,a.TYPE From dba_ddl_locks a, v$session b  Where a.session_id = b.SID;alter system kill session 'sid,serial#';

也可以从操作系统中对session进行查杀
Select spid, osuser, s.program From v$session s, v$process p Where s.paddr = p.addr and s.sid=(sid);
kill -9 spid