最初由 tolywang 发布
[B]Oracle9i
Oracle Enterprise Manager 中Lock 信息如下圖 :
其中的限制的ROWDI 表示 :數據塊號.偏移量.數據文件號
後面的資源ID1, 資源ID2表示什麼意思 ? [/B]
做一个10046可以看出，其对应的就是v$lock中的id1,和id2
[php]
SELECT :"SYS_B_00", l.sid, l.type, decode(l.lmode, :"SYS_B_01", :"SYS_B_02",
:"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07",
:"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12",
:"SYS_B_13", :"SYS_B_14", :"SYS_B_15"
"Mode", decode( l.request,
:"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20",
:"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25",
:"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30"
"Request",
:"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", l.id1, l.id2, l.block
from
v$lock l order by l.sid, l.type
ssss
[/php]
online document的解释为：Lock identifier (depends on type)
如:TM type锁时，id1表示的是表的object_id
|
