How to release a lock?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to release a lock?

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    Could anybody let me know if there is anyway to release the lock? Or I have to wait for the transaction to finish and release automatically? Thanks for reply

  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Either you maight have to wait till the end of the transaction or kill the session which is performing that transaction.

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    In most of cases Oracle automatically manages the lock mechanism.In order to release the lock give COMMIT /ROLLBACK ,oracle releases the lock.In most extreme cases ,kill the session of the user holding the lock.PMON will come into the picture and rollback the uncomitted transactions and release the resources and locks held by the user.
    In case of any doubts,write to rohitsn@htomail.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP


    [QUOTE][i]Originally posted by dragon99 [/i]
    [B]Hi, all
    Could anybody let me know if there is anyway to release the lock? Or I have to wait for the transaction to finish and release automatically? Thanks for reply [/B][/QUOTE]

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