create index online與非online在library cache lock/pin方面的區別
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create index/create index online區別Index
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- library cache lock和library cache pin區別總結
- rebuild index online和create index online及沒有online的區別RebuildIndex
- create index .. onlineIndex
- create index onlineIndex
- Create Index ...ONLINEIndex
- Library Cache Pin 及 Library Cache Lock分析
- library cache lock和library cache pin理解
- CREATE INDEX ......ONLINE分析Index
- 【ASK_ORACLE】Library cache pin 與 library load lock的關係和區別Oracle
- create index online 和create index 不同及注意點Index
- enq:Library cache lock/pin等待事件ENQ事件
- Library cache lock/pin詳解(轉)
- library cache lock\pin的查詢與處理
- library cache pin和library cache lock的診斷分析
- 定位Library Cache pin,Library Cache lock等待的解決方法
- MySQL online create index實現原理MySqlIndex
- Library cache pin/lock 在Oracle 10g的增強Oracle 10g
- oracle library cache之library cache lock_library cache pin wait event釋義OracleAI
- zt_如何平面解決library cache lock和library cache pin
- library cache pin/lock的解決辦法
- zt_library cache pin和lock等待分析
- alter index rebuild和rebuild online的區別IndexRebuild
- 0317Library Cache Pin/Lock Wait EventsAI
- zt_如何使用event 10049分析定位library cache lock and library cache pin
- Shared pool的library cache lock/pin及硬解析
- library cache lock和cursor: pin S wait on X等待AI
- [20240824]跟蹤library cache lock library cache pin使用gdb.txt
- alter index rebuild 與 rebuild onlineIndexRebuild
- Index Online RebuildIndexRebuild
- sql version count引發cursor:pin s wait x及library cache latch library cache lockSQLAI
- [20240920]跟蹤library cache lock library cache pin使用gdb.txt
- oracle11g之v$libcache_locks處理library cache lock及library cache pinOracle
- 【等待事件】library cache pin事件
- 等待事件--library cache pin事件
- library cache pin等待分析