博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
EVENT:10210 check data block integrity
阅读量:6710 次
发布时间:2019-06-25

本文共 1974 字,大约阅读时间需要 6 分钟。

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 
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

转载地址:http://eoxlo.baihongyu.com/

你可能感兴趣的文章
shell脚本获取时间、crontab、日志重定向到文件
查看>>
eclipse 中maven项目的运行
查看>>
爬虫第七章 scrapy中间件 + 基于crawlSpider全站爬取网络数据
查看>>
高校学生征信系统Postmortem结果
查看>>
How to Mount a Remote Folder using SSH on Ubuntu
查看>>
iOS开发——高级技术&签名机制
查看>>
关于Spring的配置文件的注解使用
查看>>
linux之SQL语句简明教程---ORDER BY
查看>>
DevExpress中的gridControl选择问题
查看>>
iphone-common-codes-ccteam源代码 CCRect.h
查看>>
iOS开发小技巧--初始化项目中修改APP安装后的名称
查看>>
测试人员应该高大上?!
查看>>
Python全栈开发day4
查看>>
java实现后台自动发邮件功能
查看>>
实现简单ThreadPool
查看>>
开源的api文档管理系统
查看>>
innerHTML innerText与outerHTML间的区别
查看>>
浅谈const限定符
查看>>
中国PC浏览器最新市场份额,对前端开发者来说喜忧参半!
查看>>
~~因果图法示例分析
查看>>