create index online與非online在library cache lock/pin方面的區別

wei-xh發表於2011-02-17

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部落格 ” ,連結:http://blog.itpub.net/22034023/viewspace-687468/,如需轉載,請註明出處,否則將追究法律責任。

相關文章