How PCTFREE and PCTUSED Work Together(十)
In a newly allocated data block, the space available for inserts is the block size minus
the sum of the block overhead and free space (PCTFREE).
free lists—lists of
data blocks that have been allocated for that segment’s extents and have free space
greater than PCTFREE. These blocks are available for inserts. When you issue an
INSERT statement, Oracle checks a free list of the table for the first available data block
and uses it if possible. If the free space in that block is not large enough to
accommodate the INSERT statement, and the block is at least PCTUSED, then Oracle
takes the block off the free list. Multiple free lists for each segment can reduce
contention for free lists when concurrent inserts take place.
After you issue a DELETE or UPDATE statement, Oracle processes the statement and
checks to see if the space being used in the block is now less than PCTUSED. If it is,
then the block goes to the beginning of the transaction free list, and it is the first of the
available blocks to be used in that transaction. When the transaction commits, free
space in the block becomes available for other transactions.
my question:if the space being used in the block is greater than PCTUSED then what oracle do?
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-932311/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle pctfree 和 pctusedOracle
- oracle pctfree與pctusedOracle
- oracle pctfree和pctused詳解Oracle
- pctfree和pctused的區別。
- PCTFREE, PCTUSED, and Row Chaining(七)AI
- react work with angularjs togetherReactAngularJS
- 2 Why Firms Work Together
- Oracle資料庫的PCTFREE與PCTUSEDOracle資料庫
- How Indexes Grow and PctfreeIndex
- pctused, pctfree, pctincrease , 行遷移 & 行連結
- Oracle中關於PCTFREE和PCTUSED的說明Oracle
- 建立表時引數PCTFREE和PCTUSED詳解
- How does a HashMap work in JAVAHashMapJava
- how to fix bug in daily workAI
- block學習(pctfree&pctused),行遷移問題(zt)BloC
- Oracle 空閒列表管理機制與pctfree和pctused引數Oracle
- (翻譯) How i work - Taylor Otwell
- How Logs Work On MySQL With InnoDB TablesMySql
- Oracle8i 與Oracle9i 中對pctused 和pctfree, pctincrease 的理解Oracle
- How can I work smarter, not just harder? Ask it forever
- Source Code Reading for Vue 3: How does `hasChanged` work?Vue
- Together
- SAP Retail Listing – How does it work (中英文對照版)AI
- How does ASM work with RAID where striping and mirroring are already built-in?ASMAIUI
- 【Linux】《how linux work》第二章 基本命令和目錄層次結構Linux
- golang work poolGolang
- The trees stand together with ability ranks and rune words
- How Do Vision Transformers Work?[2202.06709] - 論文研讀系列(2) 個人筆記ORM筆記
- MySQL-workbench not workMySql
- queue:work 原理分析
- RabbitMQ-Work模式MQ模式
- 【GO】Ready To WorkGo
- Pair_Work ProjectAIProject
- angularjs work with reactAngularJSReact
- Websphere (WAS) Work Load ManagementWeb
- Project Management - 2) Estimate Your WorkProject
- SQL Work Areas(101)SQL
- 為什麼索引的PCTUSED被設定為0索引