赞
踩
SQL> col event format a30
SQL> select sid,event ,p1
from v$session_wait
WHERE event not like 'SQL*N%'
and event not like 'rdbms ipc message%'
and event not like 'pmon timer%'
2 3 4 5 6 and event not like 'smon timer';
SID EVENT P1
---------- ------------------------------ ----------
9 inactive session 89
49 inactive session 89
51 inactive session 89
59 inactive session 24
94 inactive session 24
66 enqueue 1415053318
89 enqueue 1415053318
86 enqueue 1415053318
24 buffer deadlock 67130783
9 rows selected.
SQL> select s.sid,s.serial#,p.spid ,s.program,to_char(s.logon_time,'yyyymmdd hh24:mi:ss')
from v$session s, v$process p
where s.paddr=p.addr and s.sid in (24,66,89,86,58); 2 3
SID SERIAL# SPID PROGRAM TO_CHAR(S.LOGON_T
---------- ---------- --------- ------------------------------------------------ -----------------
66 27018 9733 MakePrice@db (TNS V1-V3) 20031009 10:20:24
86 14226 9529 MakePrice@db (TNS V1-V3) 20031009 10:16:32
89 31204 10022 MakePrice@db (TNS V1-V3) 20031009 10:25:44
24 43032 6666 MakePrice@db (TNS V1-V3) 20031008 19:40:01
把SPID都KILL了。
alter system kill session '24,43032';
杀不掉,为什么?如何解决?
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。