本文详细解释了Oracle数据库中Block Cleanout的概念及其两种类型：快速Block Cleanout和延迟Block Cleanout。介绍了在事务提交过程中如何清理数据块中的事务数据，包括Row Locks和ITL条目等。
为什么会有Block Cleanouts? Oracle server在执行一个交易(transaction)时会保存交易数据在数据块(data block)本身，并且一个交易有可能修改大量的数据块,因此交易需要清理这些在数据块自己上的交易数据当一个交易完成commit。
那些东西需要cleaned out?
<wbr> 1. Row Locks<br><wbr> 2. ITL Entry:<br><wbr><wbr><wbr><wbr><wbr> - Commit flags<br><wbr><wbr><wbr><wbr><wbr> - Free Space Credit/Commit SCN<br><br> Deferred Block Cleanout:<br><wbr><wbr> A transaction commit was a simple update to the relevant undo segment header.<br><wbr><wbr> The data block cleanout was left to the next reader of the modified block<br> Fast Block Cleanout: This is the default action.<br><wbr><wbr> Modified blocks are 'memorized' by a transaction. On transaction commit, cleanout is attempted<br><wbr><wbr> on those blocks in memory(up to a limit 20 blocks). For any blocks above this threshold, or<br><wbr><wbr> aged out of memory, or currently pinned by another process deferred block cleanout will be<br><wbr><wbr> still used.<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
那些东西需要cleaned out?
<wbr> 1. Row Locks<br><wbr> 2. ITL Entry:<br><wbr><wbr><wbr><wbr><wbr> - Commit flags<br><wbr><wbr><wbr><wbr><wbr> - Free Space Credit/Commit SCN<br><br> Deferred Block Cleanout:<br><wbr><wbr> A transaction commit was a simple update to the relevant undo segment header.<br><wbr><wbr> The data block cleanout was left to the next reader of the modified block<br> Fast Block Cleanout: This is the default action.<br><wbr><wbr> Modified blocks are 'memorized' by a transaction. On transaction commit, cleanout is attempted<br><wbr><wbr> on those blocks in memory(up to a limit 20 blocks). For any blocks above this threshold, or<br><wbr><wbr> aged out of memory, or currently pinned by another process deferred block cleanout will be<br><wbr><wbr> still used.<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
