oracle:查看被锁表相关信息

  在具有dba权限用户进行执行以下语句： 

1.查看被锁的表：

SELECT t.session_id as sid,
       t2.serial#,
       t.locked_mode,
       t.oracle_username,
       t.os_user_name,
       t2.machine,
       t2.terminal,
       t1.object_name,
       t2.logon_time
  FROM v$locked_object t
  left join all_objects t1
    on t.object_id = t1.object_id
  left join v$session t2
    on t.session_id = t2.sid
 ORDER BY sid, t2.serial#;

2.杀掉数据库进程(生产环境慎用)

ALTER system KILL session 'SID,serial#'; 

ps：sid 和serial为步骤1中查询出来的具体值。