查看锁

查看普通锁：
select p.spid,s.sid,
       s.serial#,
       s.username,
       s.machine,
       s.osuser,
       s.program,
       o.object_type,
       o.owner||'.'||o.object_name object,
       l.locked_mode
from v$locked_object l,dba_objects o,v$session s,v$process p
where l.object_id = o.object_id
and s.sid=l.session_id
and s.paddr=p.addr;

查看死锁：
SELECT a.sid,d.spid,e.event,C.SQL_TEXT,B.USERNAME,B.OSUSER,B.MACHINE,B.PROGRAM
FROM V$SESS_IO A,V$SESSION B,V$SQL C,V$PROCESS D,v$session_wait e
WHERE A.SID=B.SID AND B.SQL_HASH_VALUE=C.HASH_VALUE and B.sid=E.sid
AND B.PADDR=D.ADDR and A.sid in(select sid from v$Lock where block=1);