oracle 中查询锁表、kill锁表进程

-- 查询锁表                      
SELECT
  sess.sid,
  sess.serial#,
  lo.oracle_username,
  lo.os_user_name,
  ao.object_name,
  lo.locked_mode 
FROM
  v$locked_object lo,
  dba_objects ao,
  v$session sess 
WHERE
  ao.object_id = lo.object_id 
  AND lo.session_id = sess.sid; 
--杀掉锁表进程  
alter system kill session '1037,26333';--分别为SID和SERIAL#号

如果提示相关表不存在，则表示当前用户查询权限不够，先去赋权限
grant select any dictionary to 用户;