oracle数据库中查询被锁住的表

1. 查询被锁的表

select a.owner,
       a.object_name,
       a.subobject_name,
       a.object_type,
       l.session_id,
       l.oracle_username,
       l.os_user_name,
       se.SID,
       se.SERIAL#
  from  all_objects a, v$locked_object l,V$session se
where a.object_id = l.object_id
       and se.OSUSER = l.os_user_name
       and l.oracle_username = 'mcczjzx';
 

2. 杀掉导致锁表的某session     
 Alter system kill session 'SID,SERIAL#'