首先在plsql中工具中找到"会话",可以查看到sid对应的确定好status为"ACTIVE"查看sql文本是运行的哪个程序.
1\--查 sid
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
2\--查 spid
select s.sid, spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr and s.sid=26;
3\--解锁
--dos 下解锁
(dos下)orakill zzdb19(数据库) 8068(spid)
----
linux下解锁
kill -9 (spid)
--看程序跑到哪了
select b.*
from v$session a,v$sqlarea b
where a.sql_hash_value=b.hash_value
and a.sid=33
1\--查 sid
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
2\--查 spid
select s.sid, spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr and s.sid=26;
3\--解锁
--dos 下解锁
(dos下)orakill zzdb19(数据库) 8068(spid)
----
linux下解锁
kill -9 (spid)
--看程序跑到哪了
select b.*
from v$session a,v$sqlarea b
where a.sql_hash_value=b.hash_value
and a.sid=33