Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    9

    Unanswered: Oracle locking timeout?

    Do sql statements blocked waiting on a implicit Oracle lock ever timeout, or does it block until the lock is released, end of story?

    - John
    Last edited by macquivr; 07-05-06 at 14:57.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    deadlocks are deadlocks.
    normally you would have to kill the thread/session in order to release.

    if you have a for update loop then another session will wait for the row to be released.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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