ORACLE 查询锁住的表

SELECT l.session_id sid,  
       s.serial#,  
       l.locked_mode 锁模式,  
       l.oracle_username 登录用户,  
       l.os_user_name 机器用户名,  
       s.machine 机器名,  
       s.terminal 终端用户名,  
       o.object_name 被锁对象名,  
       s.logon_time 登录数据库时间  
FROM v$locked_object l, all_objects o, v$session s  
WHERE l.object_id = o.object_id  
   AND l.session_id = s.sid  
ORDER BY sid, s.serial#;  

alter system kill session '29,27795'；

alter system kill session '206,4505';

alter system kill session '398,61687';

alter system kill session '421,32969';

alter system kill session '777,43723';
alter system kill session '779,1741';
alter system kill session '1372,33051';

SELECT a.spid,
       b.sid,
       b.serial#,
       b.username,
       (SELECT t.command_name
          FROM v$sqlcommand t
         WHERE t.command_type = b.command) sql命令,
       b.osuser 操作系统用户,
       -- b.machine 计算机名,
       b.status   sql执行的状态, -- acitve:当前正在执行的SQL会话;
       c.sql_id,
       c.sql_text 正在执行的sql
  FROM v$process a, -- 当前活动进程的信息
       v$session b, -- 每个当前会话的会话信息
       v$sqlarea c -- 每个 SQL 的统计信息
 WHERE a.addr = b.paddr
   AND b.sql_hash_value = c.hash_value;