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
- [20210315]ORA-04000 the sum of PCTUSED and PCTFREE cannot exceed 100.txt
- How Logs Work On MySQL With InnoDB TablesMySql
- (翻譯) How i work - Taylor Otwell
- How does an Electric Motor work? (DC Motor)
- Source Code Reading for Vue 3: How does `hasChanged` work?Vue
- SAP Retail Listing – How does it work (中英文對照版)AI
- How Do Vision Transformers Work?[2202.06709] - 論文研讀系列(2) 個人筆記ORM筆記
- 【Linux】《how linux work》第二章 基本命令和目錄層次結構Linux
- Android workAndroid
- The trees stand together with ability ranks and rune words
- WPF Button MouseEnter and MouseLeave together play as MouseOver
- golang work poolGolang
- work 10月
- RabbitMQ-Work模式MQ模式
- MySQL-workbench not workMySql
- queue:work 原理分析
- How to ssh
- How to find dependency
- Project Management - 2) Estimate Your WorkProject
- [CF932E]Team Work
- misdirection靶機work_through
- LamPiao靶機work_throughLAMP
- [LeetCode] 2134. Minimum Swaps to Group All 1s Together IILeetCode
- [譯] WebAssembly: How and whyWeb
- How OpenStack integrates with Ceph?
- How to Build a Cybersecurity CareerUI
- CISO之What & How
- How to Restart Qt ApplicationRESTQTAPP
- How Python list works?Python
- How to Install psql on MacSQLMac
- How to Install LibreOffice on UbuntuUbuntu
- RabbitMQ(二)JavaClient SpringBoot整合 Work queuesMQJavaclientSpring Boot
- RabbitMQ學習筆記-Work QueuesMQ筆記
- WPF Backgroundworker dowork work completed progress changed
- 簡介我的 Git Work FlowGit
- 社群驅動增長 | Dev.Together 分論壇介紹dev
- How to make sense of Kotlin coroutinesKotlin
- How to Install ClamAV on CentOS 7CentOS