Oracle锁表查看，会话查看

--当前Oracle会话窗口

select * from v$session where username is not null;

 

--当前Oracle会话并发数

Select count(*) from v$session where status='ACTIVE';

 

--查看Oracle锁表记录
SELECT DISTINCT a.sid,
                 a.serial#,
                 a.username,
                 a.program,
                 c.owner,
                 c.object_name, --被锁的表名
                 a.MACHINE
   FROM v$session a, v$locked_object b, all_objects c
  WHERE a.sid = b.session_id
    AND c.object_id = b.object_id
  ORDER BY a.machine, c.object_name;

 

--查杀Oracle会话
alter system kill session 'sid,serial' ;