Rac 環境中分割槽表建立index hang(row cache lock)

renjixinchina發表於2014-06-24

今天在一張大表(分割槽表)上建立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_segments

dc_segments

dc_segments

查詢mos得知是一個bug

 10.2.0.4 RDBMS 10.2.0.4 DICTIONARY PRODID-5 PORTID-226 6004916
Abstract: CREATE BITMAP INDEX HANG ON "ROW CACHE LOCK"

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

解決方案

應用補丁 .


關閉RAC除本節點的其他節點例項,建立索引,建立後開啟其他節點例項

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-1192781/,如需轉載,請註明出處,否則將追究法律責任。

相關文章