SELECT /*+ ORDERED */

 sql_text

 FROM v$sqltext a

 WHERE (a.hash_value, a.address) IN (

 SELECT DECODE (sql_hash_value,

 , prev_hash_value,

 sql_hash_value

 ),

 DECODE (sql_hash_value, , prev_sql_addr, sql_address)

 FROM v$session b

 WHERE b.paddr = (SELECT addr

 FROM v$process c

 WHERE c.spid = '&pid'))  ----->&pid是系统进程id

 ORDER BY piece ASC

 /

 select sql_text

 from v$sqlarea sq,v$session se

 where sq.SQL_ID = se.SQL_ID

 and se.sid='&sid';

 通过SID查询会话

 select sid,serial#

 from v$session where sid='&sid';

 根据sid,serial# 值删除会话

 alter system kill session '&sid,&serial#';