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.
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
請先 登入 以發表留言。