alter index ... rebuild online的機制(zt)
當我們對索引進行rebuild時,如果不加online選項,oracle則直接讀取原索引的資料;當我們新增online選項時,oracle是直接掃描表中的資料,那如何維護索引段資料的一致性呢?就是從引開始建立到索引建立完成這段時間的資料改變...
從索引開始rebuild online開始的那一刻起,oracle會先建立一個SYS_JOURNAL_xxx的系統臨時日誌表,結構類似於mlog$_表,透過內部觸發器,記錄了開始rebuild索引時表上所發生的改變的記錄,當索引已經建立好之後,新資料將直接寫入索引,只需要把SYS_JOURNAL_xxx日誌表中的改變維護到索引中即可.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84427/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- alter index rebuild 與 rebuild onlineIndexRebuild
- alter index rebuild和rebuild online的區別IndexRebuild
- alter index ind1 rebuild 和alter index ind1 rebuild onlineIndexRebuild
- alter index rebuild online引發的血案IndexRebuild
- rebuild index online的鎖機制淺析RebuildIndex
- alter index rebuild與index_statsIndexRebuild
- Index Online RebuildIndexRebuild
- "Alter index rebuild online parallel n"會修改索引的degree屬性IndexRebuildParallel索引
- oracle10g_alter index rebuild_online_重構索引OracleIndexRebuild索引
- Oracle alter index rebuild 說明OracleIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- create index online 與rebuild index onlineIndexRebuild
- index rebuild online的問題IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(下)索引IndexRebuild
- 聊聊索引Index Rebuild和Rebuild Online(上)索引IndexRebuild
- 【羅玄】從鎖的角度看rebuild index online和rebuild indexRebuildIndex
- rebuild index online和create index online及沒有online的區別RebuildIndex
- 加快create / rebuild index的3個點(zt)RebuildIndex
- 測試index online rebuild故障記錄IndexRebuild
- “rebuild index online hang住" 問題解析RebuildIndex
- Index online operation的過程 ztIndex
- Default behavior of create & rebuild index in 10G (zt)RebuildIndex
- 關於rebuild index online 及drop index後重建問題RebuildIndex
- Online rebuild index遭遇ORA-08104RebuildIndex
- 請版主講一下rebuild index的執行機制吧?RebuildIndex
- alter index unusable 無法起作用的情況 ztIndex
- 重建索引index rebuild online vs offline vs index coalesce vs index shrik space索引IndexRebuild
- rebuild indexRebuildIndex
- index rebuildIndexRebuild
- (轉)Index Rebuild Online 過程(9i)完整版IndexRebuild
- rebuild index 排序RebuildIndex排序
- sybase rebuild indexRebuildIndex
- ORACLE中index的rebuildOracleIndexRebuild
- rebuild與rebuild online效率比對Rebuild
- best practice of rebuild your partition table local index online by using: "update indexes"RebuildIndex
- Index rebuild --case 1IndexRebuild
- 索引rebuild和rebuild online時要慎重索引Rebuild
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex