select a.program, b.spid, c.sql_text,c.SQL_ID,a.SID,a.SERIAL#
from v s e s s i o n a , v session a, v sessiona,vprocess b, v$sqlarea c
where a.paddr = b.addr
and a.sql_hash_value = c.hash_value
and a.username is not null;–正在执行的sql
select a.* from v$sql a where a.SQL_ID=‘SQL_ID’;–查询完整sql
alter system kill session ‘1325,311’;–‘sid,SERIAL#’; – 杀掉正在执行的会话