Re: why UPDATE requires share lock(S) for table joined
Posted by:
Mike Chen
Date: November 16, 2014 11:19PM
thanks for your tips.
I had a table (joined in UPDATE statement ,like lktest) involved in deadlock due to share lock .
so I tried to reduce the transaction isolation levels to avoid lock , but failed .
I know the share lock is unnecessary in SELECT due to MVCC feature, but necessary
in UPDATE according to my test . That made me confused .
Subject
Views
Written By
Posted
1864
November 12, 2014 01:03AM
1026
November 13, 2014 09:58AM
1066
November 14, 2014 03:07AM
1211
November 14, 2014 01:08PM
Re: why UPDATE requires share lock(S) for table joined
1065
November 16, 2014 11:19PM
1039
November 17, 2014 12:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.