a0b4b3a0_great_grandson_of_Husnu_Sensoy__Classical_Optimistic_Locking
[0] Death-lock/Starvation possibility [Pessimistic Locking] Higher [Description] Since you lock the table rows in pessimistic locking. In case that application server and Oracle can’t agree on connections, the lock over some will exceed although the user close its session a while ago. Or due to in appropriate order of lock accusation, sessions may fall into death-lock more easily in pessimistic locking. [Classical Optimistic Locking] 
Lower
H a r d e r
M o r e e x p e n s i v e
U s u a l l y m o r e c o m p l e x
N o
3 - t i e r a r c h i t e c t u r e
L o w e r
Y e s
A Locking Mechanism in Oracle 10g for Web Applications | The great grandson of Husnu Sensoy
Classical Optimistic Locking