0. 总共三句
select a.username, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT from v$session a, v$sqlarea b where a.sql_address = b.address;
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID
alter system kill session '36,31944';
1. 查询正在执行的sql，记住想杀死的sql的sid
select a.username, a.sid,b.SQL_TEXT, b.SQL_FULLTEXT from v$session a, v$sqlarea b where a.sql_address = b.address;
image.png
2. 查询并记住serial
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID
image.png
3. 杀死
alter system kill session '36,31944';
