Skip to Main Content
Forums

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!

Deadlock: select and DDL

slsam01Apr 3 2009 — edited Apr 8 2009
Hello,

I have an Oracle application. We have select sql statements and statements to enable constraints (for example, foreign keys and primary Key). The Select SQL statements and statement to enable constraints may be executed in parallel. Sometimes, we get deadlock. Can someone explain to me why the deadlock happened?

Thanks,

Edited by: slsam01 on Apr 3, 2009 3:18 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2009
Added on Apr 3 2009
#general-database-discussions
15 comments
3,651 views