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

Thread: How to release a lock?

  1. 02-15-2001, 11:03 AM #1
    dragon99
    dragon99 is offline Member
    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
    Reply With Quote Reply With Quote
  2. 02-15-2001, 11:16 AM #2
    sln81
    sln81 is offline Member
    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.
    Reply With Quote Reply With Quote
  3. 02-25-2001, 01:00 AM #3
    rohitsn
    rohitsn is offline Advisor
    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]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width