RAC 环境中分区表创建index hang（row cache lock）

今天在一张大表（分区表）上创建bitmap 索引,执行一段时间后就hang在那里等待事件为row cache lock查询得知:
SQL>select event,p1 from v$session a where a.username is not null and a.status="ACTIVE"EVENT P1---------------------------------------------------------------- ----------row cache lock 2查询v$rowcache SQL> select parameter from v$rowcache where cache#=7; PARAMETER--------------------------------dc_segmentsdc_segmentsdc_segments查询mos得知是一个bug
Bug 8417354 10.2.0.4 RDBMS 10.2.0.4 DICTIONARY PRODID-5 PORTID-226 6004916
Abstract: CREATE BITMAP INDEX HANG ON "ROW CACHE LOCK"

Bug 6321551 10.2.0.2 RDBMS 10.2.0.2 RAC PRODID-5 PORTID-226 6004916
Abstract: CREATE INDEX ON PART. TABLE NOT FINISHING W/ ROW CACHE LOCK

Base Bug 6004916 11.0.0.0 RDBMS 11.0.0.0 ROW CACHE PRODID-5 PORTID-46
Abstract: REFPART:LNX:WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK

When creating a local index on partitioned table is not finishing on a two node RAC. Also, ORA-4021 error could be reported after a while. 该bug出现的场景及症状1 It has not been possible to create an index on a partitioned table.
2 Error ORA-04021 may be reported after a while.
3 The table contain huge number of partitions and sub-partitions.
4 This is a 2-node RAC environment.
5 Index creation waits on "row cache lock".
6 The blocker process is not recorded in the system state dumps.解决方案应用补丁 Patch 6004916.或
关闭RAC除本节点的其他节点实例,创建索引，创建后打开其他节点实例--------------------------------------------------------------------------------Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------------------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址