|
-
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
[email protected]
-
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
[email protected]
-
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
[email protected]
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
|