rebuild index online和create index online及沒有online的區別
加 online時 :存在DDL鎖 ,但是沒有DML鎖
不加 online , DDL鎖和DML鎖都有
---------------------------------------------
普通的create index,如果沒有online,加的則是級別為4的S型別TM鎖,會阻塞DML語句加在表上面的型別為RX的TM鎖 。
剛開始要先加TM4鎖的,過程中是TM2鎖。DDL 3鎖一直都需要。
http://www.itpub.net/showthread.php?threadid=776273&pagenumber=
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84663/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- create index/create index online區別Index
- alter index rebuild和rebuild online的區別IndexRebuild
- Index Online RebuildIndexRebuild
- create index online 和create index 不同及注意點Index
- create index .. onlineIndex
- create index onlineIndex
- Create Index ...ONLINEIndex
- alter index rebuild 與 rebuild onlineIndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(下)索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(上)索引IndexRebuild
- CREATE INDEX ......ONLINE分析Index
- index rebuild online的問題IndexRebuild
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- alter index rebuild online引發的血案IndexRebuild
- alter index ... rebuild online的機制(zt)IndexRebuild
- create index online與非online在library cache lock/pin方面的區別Index
- 測試index online rebuild故障記錄IndexRebuild
- “rebuild index online hang住" 問題解析RebuildIndex
- MySQL online create index實現原理MySqlIndex
- rebuild index online的鎖機制淺析RebuildIndex
- Online rebuild index遭遇ORA-08104RebuildIndex
- 重建索引index rebuild online vs offline vs index coalesce vs index shrik space索引IndexRebuild
- Creating an Index OnlineIndex
- oracle10g_alter index rebuild_online_重構索引OracleIndexRebuild索引
- (轉)Index Rebuild Online 過程(9i)完整版IndexRebuild
- "Alter index rebuild online parallel n"會修改索引的degree屬性IndexRebuildParallel索引
- Index online operation的過程 ztIndex
- best practice of rebuild your partition table local index online by using: "update indexes"RebuildIndex
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex
- 索引rebuild和rebuild online時要慎重索引Rebuild
- ORA-08104@ONLINE_INDEX_CLEANIndex
- Creating an Index Online - 線上建立索引Index索引
- 建立index 使用Online導致的問題Index
- create index...online操作過程中會申請持有哪些鎖Index