查询锁阻塞

查询那些用户，操纵了那些表造成了锁机
/Hv X S
d5Vc0SELECT s.username,
{;rA/es0       decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
@6\'rVAD0       o.owner,
'e'ApH!^I~.Zve.q0       o.object_name,
b Z
^ e(}7[R.P0       o.object_type,51Testing软件测试网!{!F"Ybc ]
       s.sid,51Testing软件测试网z-S'lA+@2fuv
       s.serial#,51Testing软件测试网1{1r0o?&x$rRhx^g
       s.terminal,
oj-KHHs0       s.machine,
*MC$Z0w3MOm0       s.program,51Testing软件测试网O}^8lOEi
       s.osuser51Testing软件测试网^Pq3F1yxQ
  FROM v$session s, v$lock l, all_objects o
;` ? j(ea\ w5e1a4J @0 WHERE l.sid = s.sid
.a
VYnhv\0   AND l.id1 = o.object_id(+)
-p~(PM F j0   AND s.username is NOT Null51Testing软件测试网}%LUi,\qoi D
其中 TM  为表锁定  TX 为行锁定  51Testing软件测试网2\.k ~qp[hmV)q

3v7q$~Ez @ }d0看锁阻塞的方法是
.Djg[W1Z(U]0SELECT (select username FROM v$session WHERE sid = a.sid) blocker,51Testing软件测试网+[N(?'{d)E)\$C
       a.sid,
9L`ig4CPubA0       'is blocking',51Testing软件测试网9b? \8l:Wm
x
W
{
       (select username FROM v$session WHERE sid = b.sid) blockee,51Testing软件测试网LmTZ2X0L2j@ @d-T
Y
       b.sid51Testing软件测试网U"I|
EW
  FROM v$lock a, v$lock b51Testing软件测试网/u*No/b/`6p;rB
H5Q
 WHERE a.block = 1
_ ]bR9NJ@!n0   AND b.request > 051Testing软件测试网e7F.m[o;@)R `
   AND a.id1 = b.id1
g7H v(C J [e0   AND a.id2 = b.id251Testing软件测试网b4BC$t5O%\