online 创建的时候,索引的共享池内容如下,LOCK和PIN都是0,没加任何形式的锁。
BUCKET#127039 mtx=0xa275dc48(0, 294, 0):
LIBRARY HANDLE:0x9ac96748 bid=127039 hid=720ff03f lmd=0 pmd=0 sta=VALD
name=APOLLO.GLOBAL_ACCOUNT_BIZ_GID_IND
hash=a037d648070d14565c23487d720ff03f idn=0
tim=02-17-2011 22:11:30 kkkk-dddd-llll=0000-0041-0041
exc=0 ivc=0 ldc=18 slc=0 lct=125 pct=126
cbb=35 rpr=25 kdp=0 kep=0 bus=126 hus=126 dbg=0
dmtx=0x9ac967f0(0, 0, 0) mtx=0x9ac96858(3263, 1019, 0)
nsp=INDX(04) typ=INDX(01) llm=0 flg=TIM/[00006800]
lwt=0x9ac967d0[0x9ac967d0,0x9ac967d0]
pwt=0x9ac967b0[0x9ac967b0,0x9ac967b0]
ref=0x9ac967e0[0x9ac967e0,0x9ac967e0]
LIBRARY OBJECT: 0x89952988
flg=EXS/LOC[0005] pfl=[0000] ssta=VALD
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 8e8ed3c8 89952a68 89952958 I/-/A/-/- 0 NONE 00
当不加ONLINE选项的时候,共享池内容如下,增加了X模式的LOCK和PIN
BUCKET#127039 mtx=0xa275dc48(0, 286, 0):
989c28f0 9ab05cf0 DEP[01]
timestamp=01-19-2010 15:56:05 whr=0
98aad400 9acd5020 DEP[01]
timestamp=01-19-2010 15:56:05 whr=0
LOCK OWNERS:
LIBRARY HANDLE:0x9ac96748 bid=127039 hid=720ff03f lmd=X pmd=X sta=VALD
name=APOLLO.GLOBAL_ACCOUNT_BIZ_GID_IND hash=a037d648070d14565c23487d720ff03f idn=0 tim=02-17-2011 22:11:30 kkkk-dddd-llll=0000-0041-0041 exc=0 ivc=0 ldc=18 slc=1 lct=119 pct=120 cbb=34 rpr=25 kdp=0 kep=0 bus=120 hus=120 dbg=0 dmtx=0x9ac967f0(0, 0, 0) mtx=0x9ac96858(3263, 982, 0) nsp=INDX(04) typ=INDX(01) llm=0 flg=KGHP/TIM/[00006800] lwt=0x9ac967d0[0x9ac967d0,0x9ac967d0]
pwt=0x9ac967b0[0x9ac967b0,0x9ac967b0]
ref=0x9ac967e0[0x9ac967e0,0x9ac967e0]
LOCK OWNERS:
lock user session count mode flags
-------- -------- -------- ----- ---- ------------------------
8e8c0c68 ae987670 ae987670 1 X CNB/[01]
PIN OWNERS:
pin user session lock count mode mask
-------- -------- -------- -------- ----- ---- ----
8e8f2fe8 ae987670 ae987670 0 1 X 0001
LIBRARY OBJECT: 0x89952988
flg=EXS/LOC/UPD[0105] pfl=[0000] ssta=VALD
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 8e8ed3c8 89952a68 89952958 I/P/A/-/- 0 NONE 00
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22034023/viewspace-687468/ ,如需转载,请注明出处,否则将追究法律责任。