查询Oracle SessionID对应的系统进程ID:
select p.addr,P.PID,P.PID, s.paddr,p.SPID from v$process p,v$session s
where P.ADDR=S.PADDR and s.SID=830;
查锁表:
select o.object_name,
l.session_id,
s.serial#,
s.program,
s.username,
s.command,
s.machine,
s.lockwait
from v$locked_object l, all_objects o, v$session s
where o.object_id = l.object_id
and s.sid = l.session_id