Row Chaining and Migrating(六)
In two circumstances, the data for a row in a table may be too large to fit into a single
data block. the first is case, the row is too large to fit into one data block when it is first
inserted. In this case, Oracle stores the data for the row in a chain of data blocks (one
or more) reserved for that segment.Row chaining most often occurs with large rows such as long ,long raw ,unavoidable.
thsi second is a row that originally fit into one data block is updated so
that the overall row length increases, and the block’s free space is already completely
filled. In this case, Oracle migrates the data for the entire row to a new data block,
assuming the entire row can fit in a new block.The rowid of a migrated row does not change.
When a row is chained or migrated, I/O performance associated with this row decreases.
my question :
1 what's row piece
2 why i/o performance decreases(the last sentence)
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-932234/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Row Chaining and MigratingAI
- PCTFREE, PCTUSED, and Row Chaining(七)AI
- Row Migration and Row Chaining(行遷移和行連結)AI
- 【轉載】行遷移和行連結(row chaining or row migration)AI
- 行連結(Row chaining)和行遷移(Row Migration)的讀書筆記AI筆記
- Redo內部解析-Single Row Delete (六)delete
- 精讀《Optional chaining》AI
- Migrating to a Server Parameter FileServer
- JavaScript 裡的 Promise ChainingJavaScriptPromiseAI
- Row Migration和row chainedAI
- R language notes | pipes: chainingAI
- Migrating to ASM Using RMAN(二)ASM
- Migrating to ASM Using RMAN(一)ASM
- 14-2 鏈地址法 Seperate ChainingAI
- TypeScript 中 Optional Chaining 和 Nullish CoalescingTypeScriptAINull
- 6.2、串連ViewResolver(Chaining ViewResolvers)ViewAI
- Chaining If Else Statements 巨坑的題目AI
- MySQL裡的found_row()與row_count()MySql
- How to Match a Row Cache Object Child Latch to its Row CacheObject
- ORACLE ROW MOVEMENTOracle
- list chained rowAI
- A. Arrow a Row
- FROM ASM Migrating to FILE SYSTEM Using RMAN(三)ASM
- js方法鏈(Method Chaining)簡單介紹JSAI
- oracle效能診斷例項-row migration and row chainOracleAI
- Metlink:How to Match a Row Cache Object Child Latch to its Row CacheObject
- Migrating an ASP.NET MVC application to ADFS authenticationASP.NETMVCAPP
- 為什麼我喜歡JavaScript的Optional ChainingJavaScriptAI
- Migrating Oracle10g Database to Automatic Storage management (ASM)OracleDatabaseASM
- MySQL二進位制日誌Mixed格式轉化為row格式的六種情況總結MySql
- row cache objects latch研究Object
- ROW-NUMBER()函式函式
- Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0Linux
- jQuery|開發了這麼多年終於懂了“鏈(Chaining)”jQueryAI
- enq: TX - row lock contentionENQ
- Flutter 之 Row、Column詳解Flutter
- flutter佈局-2-rowFlutter
- 等待事件之Row Cache Lock事件