oracle锁表解锁

oracle锁表解锁

1.使用SYS登陆

su - oracle 
sqlplus
sys as sysdba

2.设置显示宽度

set linesize 380;

3.查询锁表进程

SELECT l.session_id sid,  
       s.serial#,  
       l.locked_mode,  
       l.oracle_username,  
       l.os_user_name,  
       s.machine,  
       s.terminal,  
       o.object_name,  
       s.logon_time,  
       p.SPID  
  FROM v$locked_object l, all_objects o, v$session s,v$process p  
 WHERE l.object_id = o.object_id  
   AND l.session_id = s.sid  
   AND s.paddr = p.addr  
 ORDER BY sid, s.serial#;  

4.杀掉进程

alter system kill session '24,111'; (其中24,111分别是上面查询出的sid,serial#)