Event:10210 See for similar events / parameters ~~~~~~~~~~~ Version/Use: 7.0 - 8.1.7 Check data block integrity after each modification 9.0+ This event is no longer valid. Use <Parameter:DB_BLOCK_CHECKING> instead. 7.0 - 8.1.7 "Check data block integrity after each modification" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTE: Events should NEVER be set by customers unless advised to do so by Oracle Support Services. Read before setting any event. Summary Syntax: This event should be set at instance level: EVENT="10210 trace name context forever, level 10" Levels: This event is either ON (level 1 or higher) or OFF (not set) Note that in 8.1.6 onwards you should use the instead of this event. Description/Steps: Event 10210 enables data block integrity checking. This causes the data layer to perform a number of checks on the contents of a data block. If the block is found to be corrupt in some way it is marked as SOFTWARE CORRUPT. NB: Blocks are ONLY checked/corrupted when CHANGED. They are NOT checked when accessed for read. Take care with this, as if there are blocks in the database which are being accessed happily but have a minor corruption such as an incorrect free space count, this event will mark the block as corrupt. Once marked SOFTWARE CORRUPT the data in the block is not accessible to Oracle. See for more detail of various block checking features. Example Output / Interpreting Output: This event will cause an ORA-600 error to be signalled if a corruption is detected after a data block has been modified. The exact content of the trace file depends on the ORA-600 and the action at the time of the corruption being noticed. Refer to the relevant ORA-600 article for the error which is signalled. Related: Database block checking features Index and Cluster block equivalents See event 10231 which allows SOFTWARE CORRUPT blocks to be skipped on full table scans
EVENT:10210 check data block integrity
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Linux系统之部署web-check网站分析工具
Linux系统之部署web-check网站分析工具
bash apache web Linux -
EVENT:10211 check index block integrity
Event:10211
Oracle 数据库 event check block -
XFS - Data Block Sharing (Reflink)
XFS - Data Block Sharing (Reflink)Matt KeenanFollowing on from his recent blogXFS - 2019 Development Retrospective, XFS Upstream maintainer Darrick Wong dives a little deeper into the Reflinks implementation for XFS in the mainline Linux Kernel....
linux xfs reflink RHEL8 Oracle Linux 8