ORACLE锁表，杀进程

select b.owner, b.object_name, a.session_id, a.locked_mode
  from v$locked_object a, dba_objects b
 where b.object_id = a.object_id;
 
 
 select b.username, b.sid, b.serial#, logon_time
   from v$locked_object a, v$session b
  where a.session_id = b.sid
  order by b.logon_time;

alter system kill session '127,30603'

偶偶，锁表以后杀死锁表进程，网上很多了  ，这个只是方便自己查询，备注下

dont' worry   ,be   happy