ora 600[ktspfmdb:objdchk_kcbnew_3] [0], [6059381], [4]

oracle support 建议重建索引和表,暂时没有发现错误,期待是这样哦,以下是该错误的 oracle 说明

ERROR:

  Format: ORA-600 [ktspfmdb:objdchk_kcbnew_3] [a] [b] [c] [d] [e]

  Versions 11.2 and above


DESCRIPTION:

  This error occurs when ktspfmdb() calls kcbnew() to format a range of blocks. The error is raised in kcbnew() if the data_object_id of the current buffer in cache is different to the object that we're trying to new the buffer for.


ARGUMENTS:

 Arg [a] -- Number of block to new within range 
 Arg [b] -- Data_object_id that kcbnew() is expecting to see  
 Arg [c] -- Buffer flag

FUNCTIONALITY:

   Kernel Cache Buffer Management Implementation


IMPACT:

    PROCESS FAILURE


SUGGESTIONS:

The incident trace file dumps the buffer header that we find at the top of the trace. This will show the data_object_id that is found in the buffer.
We need to see the pinned buffer history for the block to diagnose further. To get enough information, it is usually necessary to set _db_block_cache_history=32 to increase the size of the history. 


The fpin: entry in the buffer header will show where in the code the data block was brought into cache and this can help identifying known bugs or the area which is mishandling the buffer.


DETAILS

SUGGESTIONS:

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle 
  Support Services for further analysis.

  Known Issues:

You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button: 
                         

The list below is restricted to show only bugs believed to affect version 11.2.0.4.
Other bugs may affect this version but have not been confirmed as being relevant yet.

There are 2 bugs listed.
NBProbBugFixedDescription
III1966317612.2.0.0ORA-600 [ktspfmdb:objdchk_kcbnew_3] using AQ
IIII1758695511.2.0.4.4, 11.2.0.4.BP11, 12.1.0.1ORA-600 [ktspfmdb:objdchk_kcbnew_3] in RAC
  • '*' indicates that an alert exists for that issue.
  • '+' indicates a particularly notable issue / bug.
  • See Note:1944526.1 for details of other symbols used



REFERENCES

NOTE:12323180.8  - Bug 12323180 - ORA-600 [ktspfmdb:objdchk_kcbnew_3] due to re-used block read into cache
NOTE:12747437.8  - Bug 12747437 - ORA-600 [ktspfmdb:objdchk_kcbnew_3] after purging single consumer queue table
NOTE:9456964.8  - Bug 9456964 - OERI[kcbnew_3] after shrinking an IOT and reusing the blocks freed by shrink
NOTE:10137834.8  - Bug 10137834 - ORA-600 running DBMS_XDB.MOVEXDB_TABLESPACE
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值