Why the inactive session still lock the table record
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Why the inactive session still lock the table record

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Why the inactive session still lock the table record

    I did below testing:

    1. User A login to sqlplus , do
    select * from t1 where c1 = 1 for update nowait

    2. User B login to sqlplus , do
    update t1 set c2 = 2 where c1 = 1 ( it has to wait ,good)

    3. Disconnect UserA 's network with oracle server .
    I expect that oracle release the lock which holded by UserA as the connection is lost .

    4. But the update statement still waiting !
    5. I manuall kill session ( inactive session of UserA) , the update statement from userB can continue .

    It seems oracle can not claim the lock back even the session is lost !

    Can anyone explain about that ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    I leave the disconnect session and try to find the status tomorrow.
    so far the disconnect session still lock the table !

    My oracle is oracle9.2.0 , is it a bug
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    after one night , the disconnect session disappear and lock is released !
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

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