B*****g
发帖数: 34098 | 1 mutiple sessions insert (2 tables and only insert), 00060 error， oracle 9i，
deadlock似乎两个table都有。能是什么原因? 一个table好像有bitmap，另一个不确定
。会不会是ITL shortage？DBA不help。
谢谢 | v*****r
发帖数: 1119 | 2 Drop bitmap index,it is the cause of dead lock in your case, not ITL slot. | B*****g
发帖数: 34098 | 3 我觉得也是。另一个table也有bitmap，不知道哪个变态加的，现在谁都不承认
【在 v*****r 的大作中提到】
: Drop bitmap index,it is the cause of dead lock in your case, not ITL slot.
| v*****r
发帖数: 1119 | 4 嘿, that is why we need "change control" in place. | B*****g
发帖数: 34098 | 5 hehe, that is why we need CTO to say "if you don't follow standard, you are
fired"
【在 v*****r 的大作中提到】
: 嘿, that is why we need "change control" in place.
|
|
