oracle数据库锁表、执行sql、删除锁表方法

1. 锁表查询

select o.*, s.*
  from v$locked_object l
 inner join dba_objects o
    on l.object_id = o.object_id
 inner join v$session s
    on s.sid = l.session_id;

2. 查看执行sql

select t.sid, t.serial#, t.wait_class, s.sql_id, s.sql_text, t.status
  from v$session t, v$sql s
 where t.sql_id = s.sql_id
   and t.status = 'ACTIVE'
   and s.sql_text like '%t_test%';

3. 删除锁表

alter system kill session 'sid,serial#';
--如：
alter system kill session '4506,30269';