数据库正在执行的语句查询

---数据库正在执行语句

select a.program, b.spid, c.sql_text,c.SQL_ID,a.SID,a.SERIAL#

from v$session a, v$process b, v$sqlarea c

where a.paddr = b.addr

and a.sql_hash_value = c.hash_value

and a.username is not null order by sql_text;

---kill掉这些正在执行的语句

select 'alter system kill session '||''''|| a.SID||','||a.SERIAL#||''''||';'

from v$session a,v$process b,v$sqlarea c where a.paddr=b.addr

and a.sql_hash_value=c.hash_value and a.username is not null ;

---如果杀不掉提示ORA-00031: session marked for kill记录下需要杀掉的进程的sid

select spid, osuser, s.program

from v$session s,v$process p

where s.paddr=p.addr and s.sid in ('1352','1347','196')

---在系统层面直接kill -9 spid

转载于:https://www.cnblogs.com/1234qq/p/7085019.html