关于'kksfbc child completion' wait的一个bug

转载 2011年01月18日 16:51:00

一个跑在aix操作系统上的Oracle 10.2.0.3的数据库,经常出现'kksfbc child completion' 的等待事件,并且这些等待事件一旦出现,这些等待事件和相关的session永远不会消失。


发现这个问题后,首先想到可能是oracle的bug,在metalink上查询这个等待事件,发现两个bug:


1、Bug 6795880,相关的doc id为:6795880.8
A session may go into an infinite spin just after a wait for 'kksfbc child completion'. The spin occurs with a stack including kksSearchChildList -> kkshgnc where kksSearchChildList loops forever.
This problem can also lead to internal error such as any of
ORA-600 [kksSearchChildList1], ORA-600 [kksSearchChildList2]
ORA-600 [kksSearchChildList3], ORA-600 [kkshgnc-nextchild]
Note:
Fixes for this bug in 10g and 11gR1 are disabled by default.
To enable this fix you must explicitly set the following parameter for instance startup:
"_cursor_features_enabled" = 10

2、Bug 5500044,相关的doc id为:430555.1
Cause Execution of DDL against a partitioned object which has a object-based column (CLOB in this particular case) could result in sessions blocking on the 'cursor: pin X' and 'kksfbc child completion' wait events.
Database Hung With "kksfbc child completion" and "Cursor: Pin X" Waits [ID 430555.1]
This is due to Bug 5500044 (Bug 5217203 is closed as duplicate)
Bug 5217203 - SYSTEM STATES DUMPED TO TRACE FILE MESSAGES IN ALERT.LOG
Bug 5500044 - ORA-44203 ON TABLE_X_X CHILD FROM CONCURRENT LOB APPEND AND DROP PARTITION
To be seeing this problem under 10.2 then you are likely to need to see the following:
1) DDL on a partitioned table
2)Sessions block on 'cursor: pin X' and 'kksfbc child completion'
3)The 'cursor: pin X' is waiting on a pseudo cursor (a cursor with a name that starts with "table_")
4)The partitioned table has an object column (LOB, CLOB etc)
Note:- This issue can also be seen on partitioned table no having object columns like LOB,CLOB, etc.
Solution Please download and apply patch 5500044 for your platform.
This bug has been fixed in 10.2.0.4 and 11g. In case the patch is not available for your platform, then raise a service request with Oracle support for requesting the same

经检查,在数据库中没有使用分区表,并且客户表示没有在数据库上执行过ddl语句,不符合Bug 5500044的描述,确定为Bug 6795880,解决方法是设置隐含参数:
"_cursor_features_enabled" = 10 过程如下:

SQL> alter system set "_cursor_features_enabled" = 10 scope=spfile;
SQL> shutdown immediate;
SQL> startup;

 

 

 

from:http://cnhtm.itpub.net/post/39970/494626

[cocos2d-x BUG1]CCLabelBMFont,字符作为child引用会存在错位

问题出现的条件: 设定宽度,且setLineBreakWithoutSpace(true) 问题描述: 处理自动分行逻辑时,会对字符做变换添加换行符\n,并再次调用createFontChars,此...
  • jusnxie
  • jusnxie
  • 2013年09月10日 14:52
  • 1971

Oracle bug之new child listener process forked

Oracle bug之new child listener process forked
  • aicon
  • aicon
  • 2011年04月01日 00:30
  • 424

一个理解wait()与notify()的例子

  • 2007年04月20日 15:52
  • 30KB
  • 下载

ExpandableListView(三)只展开一个group,没有child不展开group

本文是自己在实践中,发现的问题。 有时候想让界面更加的人性化,就要实现很多的效果,比如只展开一个group,在点击下个group的同时,关闭之前的group 在一个ExpandableList...

ExpandableListView(三)只展开一个group,没有child不展开group

本文是自己在实践中,发现的问题。 有时候想让界面更加的人性化,就要实现很多的效果,比如只展开一个group,在点击下个group的同时,关闭之前的group 在一个Expandable...

关于TCP的CLOSING状态和CLOSE_WAIT状态浅析(附带一个2.6.32内核tun驱动BUG定位)

很多资料讲了关于TCP的CLOSING和CLOSE_WAIT状态以及所谓的优雅关闭的细节,多数侧重与Linux的内核实现(除了《UNIX网络编程》)。本文不注重代码细节,只关注逻辑。所使用的工具,tc...
  • dog250
  • dog250
  • 2016年07月30日 08:39
  • 2958

一个解除TCP连接的TIME_WAIT状态限制的简便方法

/*************************************              版权声明*   本文为本人原创,本人拥有此文的版权。鉴于本人持续受益于开源软件社区,* 本人声明...
  • kaylc
  • kaylc
  • 2011年02月26日 15:55
  • 759
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:关于'kksfbc child completion' wait的一个bug
举报原因:
原因补充:

(最多只允许输入30个字)