close


A ORA-00060 "deadlock detected"  can be the fact that the table and index INITRANS is set too low.  In addition, bitmap index can also affect the OTLP system.

Solution:
1. alter table [TABLE_NAME] initrans 100;

2. alter index [INDEX_NAME] initrans 100;

3. replace bitmap indexes with B-tree indexes.

 

[Refernece]
    1. http://www.dba-oracle.com/t_initrans.htm
    2. http://www.akadia.com/services/ora_bitmapped_index.html
   

分享
Facebook Plurk YAHOO!
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 DanBrother 的頭像
    DanBrother

    DanBrother的部落格

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄