Deadloack
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Deadloack

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    If I insert and Update on the same table at the same time, will it create a deadlock?

    Thanks in Advance

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Sorry, I don't have access to metalink. Any suggestion

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If the Insert and update is within the same session then no, the premiss behind a deadlock is that sessionA requests an object which is locked by sessionB at the same time sessionB is attempting to use the object SessionA is locking.

    Regards

    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width