Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dead lock detected, how to fix?

s9225May 12 2009 — edited May 12 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 12 2009
6 comments
882 views