dead lock detected, how to fix?
s9225May 12 2009 — edited May 12 2009Hi,
we are using informatic (open three sessions simutaneously) to insert data into table A, then dead lock detected during inserting and insert work failed. (after insert failure in those sessions, dead lock problem was gone too--it only happened during the inserting).
we newly built a couple of b-tree and bit map indexes on that table A.
We suspect that while inserting data, on the same time, oracle is building indexes, then it cause session to work longer, then cause locks problem.
so we dropped all indexes, and insert again, then it succeeded. ( no locke detected)
the only thing is we really want those indexes on that table....
How can we resovle this problem?
Thanks a lot
Jerry