oracle 下查看锁表进程

为什么80%的码农都做不了架构师？>>>   

查询sessionId

SELECT object_name || ',' || machine || ',' || s.sid || ',' || s.serial#,sql_id

  FROM v$locked_object l, dba_objects o, v$session s

 WHERE l.object_id = o.object_id

   AND l.session_id = s.sid;

   

 杀死进程id

 

 alter system kill session '200,17209'; 

转载于:https://my.oschina.net/myc/blog/53710