Format: ORA-600 [kcbnew_3] [a] [b] [c]VERSIONS:versions 9.2 and later DESCRIPTION:A cache buffer holding a database block is in the process of being reused.The buffer is in state "current" and may be reused only if the object is of type temp or undo.The consistency c...
1. ORA-600 [kcbnew_3] internal error reported in the alert.log 2. May occur if segment advisor and DROP operation are being run concurrently on the same object. Workaround : sql>alter system flush buffer cache' to flush the buffer in the cache. Patch Details: Check Metalink for Patch ...
BUG:7429941- ORA-00600[KCBZ_CHECK_OBJD_TYP_1] SOMETIMES OCCURS NOTE:4430244.8- Bug 4430244 - Segment advisor can load blocks of dropped objects into buffer cache (KCB OERI errors) NOTE:5218905.8- Bug 5218905 - OERI[kcbnew_3] when segment advisor has been used...
BUG:7429941- ORA-00600[KCBZ_CHECK_OBJD_TYP_1] SOMETIMES OCCURS NOTE:4430244.8- Bug 4430244 - Segment advisor can load blocks of dropped objects into buffer cache (KCB OERI errors) NOTE:5218905.8- Bug 5218905 - OERI[kcbnew_3] when segment advisor has been used...
我正在经历几个ORA-00600错误事件,大概是在异常高的I/O期间,有人知道我在哪里可以查找ktspfmdb:objdchk_kcbnew_3的下列参数的含义吗?ORA-00600: internal error code, arguments: [ktspfmdb:objdchk_kcbnew_3], [13], [873730], [4], [], [], 浏览0提问于2015-05-08得票数 0 回答已采纳 ...
/opt/app/oracle/diag/rdbms***/trace/***_ora_34345.trc ORA-00600: 内部错误代码, 参数: [ktugnb:clschk_kcbnew_14], [0], [1906], [4], [], [], [], [], [], [], [], [] === Dump for incident 1320754 (ORA 600 [ktugnb:clschk_kcbnew_14]) === --- Beginning of Customi...
ORA-00600: internal error code, arguments: [ktspfmdb:objdchk_kcbnew_3], [1], [87561], [4], [], [], [], [], [], [ 所以objdchk_kcbnew_3是我们分析的重点。 这个ORA-00600的参数代表什么含义呢。我们可以找到一些端倪。比如我们抓取的trace日志里面含有下面的信息。
ORA-00600[kcbnew_3] [a] [b] [c] 是Oracle 9i 9.2之后引入的新的块检测机制。一个存有数据块的cache buffer在被重用的过程中,buffer的状态为state且数据为temp或undo。 oracle一致性检查比较了buffer header的block class和传递给调用者的block class并发现不一致。
解决ORA-00600:[kcbgcur_3]一例 ,kcbgcur_3这个函数出现ORA-00600错误一般是告诉我们,当一个状态为”CURRENT”的cache buffer中存放的是程序所预期的数据地址,即TABLESPACE号和相关DBA(RDBA),但Oracle却发现这个block并不属于一个预期的OBJECT(实际是发现了不同的Data_object_id)。
11902008 12.1.0.0 SMON may crash with ORA-00600 [kcbgcur_3] or ORA- 600 [kcbnew_3] during Transaction recovery 7227645 11.1.0.7, 11.2.0.1 OERI[kcbgcur_3]/OERI[kcb_check_objd_typ] during INSERT on freelist-managed segment 6444339 10.2.0.5, 11.2.0.1 Truncate/purge does not clean AQ depend...