oracle 表被锁的处理方法

--1.查看哪张表被哪个进程锁了
select vlo.object_id, vpc.spid, vlo.session_id, vse.serial#,
       vlo.oracle_username, vlo.os_user_name, ao.object_name, vse.process
  from v$locked_object vlo, v$session vse, all_objects ao, v$process vpc
 where vlo.session_id = vse.sid
   and vlo.object_id = ao.object_id
   and vpc.addr = vse.paddr
   and vlo.os_user_name = 'ZHI001'   --用户名
   and ao.object_name = 'TEST_ZHI';                --表名


--2. 杀掉进程
alter system kill session 'session_id, serial#'