--查询锁表
select a.sid,a.type,a.id1,c.object_name,b.username,a.lmode,B.MACHINE,D.SPID
from v$lock a,v$session b,all_objects c,V$PROCESS D
where a.sid=b.sid and a.type in ('TM','TX')
and c.object_id=a.id1
AND B.PADDR=D.ADDR
order by username
--生成杀进程语句
SELECT 'alter system kill session '||''''||TO_CHAR(sid)||','||TO_CHAR(serial#)||''''||';'
from v$session
WHERE SID=&SID
select a.sid,a.type,a.id1,c.object_name,b.username,a.lmode,B.MACHINE,D.SPID
from v$lock a,v$session b,all_objects c,V$PROCESS D
where a.sid=b.sid and a.type in ('TM','TX')
and c.object_id=a.id1
AND B.PADDR=D.ADDR
order by username
--生成杀进程语句
SELECT 'alter system kill session '||''''||TO_CHAR(sid)||','||TO_CHAR(serial#)||''''||';'
from v$session
WHERE SID=&SID