Results 1 to 7 of 7

Thread: Releasing locks

  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Unanswered: Releasing locks

    Hello.
    Is there any parameter (Oracle8174) to release locks that remain in the DB for more than X time?
    Regards,
    Manf

  2. #2
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Any idea with this?
    Regards,

    Manf

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Locks should not be released just because time has passed. You might have a long running query that has a lock set. To just release a lock because you feel like it would cause data corruption.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    hence the word LOCK. It's locked.
    Depends on how/why you are using the lock (if you even know you are locking)

    Anyways, you would have to end the transaction or session in order to release the lock.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    are we talking a LOCK a BLOCK or a DEADLOCK?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Ok, thanks all for your comments.
    I need to release some locks because developers are "tunning" code, thus records remain locked for long time till sql statemets end (we're talking about blocks locks).
    Thats why I need to set some parameter (or mecanism) to realease those locks. Can it be set?
    Regards,

    Manf

  7. #7
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    No timeouts for any sort of locks in oracle. You will either have to alter your code, kill the session or live with the locked records. NOTE oracle is much more 'tolerant' of locked records as writers dont block readers or vici versa and writers dont block writers unless they both want to write to the same record (unlike sqlserver,sybase,db2 etc).

    Alan

Posting Permissions

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