下面语句查询,某一个连接最近执行的sql语句,其中sid是你要查的v$session中的sid, select distinct a.piece,a.sql_text from v$sqltext_with_newlines a,v$open_cursor b,v$session c where a.address=b.address and a.hash_value=b.hash_value and b.saddr=c.saddr and c.sid=9 and b.sid=9 order by piece ASC;
alter system kill session 'sid, serial#';
select distinct a.piece,a.sql_text from v$sqltext_with_newlines a,v$open_cursor b,v$session c where a.address=b.address and a.hash_value=b.hash_value and b.saddr=c.saddr and c.sid=9 and b.sid=9 order by piece ASC;