SELECT p.spid,p.USERNAME as proname, s.USERNAME,s.STATUS,s.OSUSER,s.MACHINE, s.program,s.sid,s.PADDR,a.OBJECT FROM v$process p, v$session s,V$ACCESS a WHERE p.addr=s.paddr and a.SID=s.SID and a.TYPE = 'PROCEDURE' and s.OSUSER='Administrator' 杀掉spid所标识的那个进程 D:>orakill sid spid (注:cmd命令窗口中执行 只有oracle服务器端才有orakill命令) example: D:>orakill oemrep 1204提示:KILL OF THREAD id 1204 IN INSTANCE oemrep successfully signalled.结果:成功删除该SESSION,表也解锁
或者直接在v$session中查询 然后用ALTER SYSTEM KILL SESSION 'sid, serial#';去删除会话
select /*+ rule */ s.username, decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', null) LOCK_LEVEL, o.owner, o.object_name, o.object_type, s.sid, s.serial#, s.terminal, s.machine, s.program, s.osuser from v$session s, v$lock l, dba_objects o where l.sid = s.sid and l.id1 = o.object_id(+) and s.username is not null;
http://topic.csdn.net/t/20030520/11/1807933.html
SELECT p.spid,p.USERNAME as proname, s.USERNAME,s.STATUS,s.OSUSER,s.MACHINE, s.program,s.sid,s.PADDR,a.OBJECT
FROM v$process p, v$session s,V$ACCESS a
WHERE p.addr=s.paddr
and a.SID=s.SID
and a.TYPE = 'PROCEDURE'
and s.OSUSER='Administrator' 杀掉spid所标识的那个进程 D:>orakill sid spid (注:cmd命令窗口中执行 只有oracle服务器端才有orakill命令)
example: D:>orakill oemrep 1204提示:KILL OF THREAD id 1204 IN INSTANCE oemrep successfully signalled.结果:成功删除该SESSION,表也解锁
s.username,
decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', null) LOCK_LEVEL,
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#,
s.terminal,
s.machine,
s.program,
s.osuser
from v$session s, v$lock l, dba_objects o
where l.sid = s.sid
and l.id1 = o.object_id(+)
and s.username is not null;
dba_dml_locks;
dba_ddl_locks;