Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    64

    Unanswered: Need Advice on deadlock issues

    In case of deadlock on records , is there a way to get the details of the locked records ? Can we retrieve the records ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    true DEADLOCK throw ORA-00060 & are logged into alert_SID.log file
    Oracle DB terminates one of the two sessions involved in order to break the deadlock.

    other (b)locking events are deemed to be application issues to be resolved by normal application debugging
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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