pessimistic locking vs optimistic locking

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5771117722373

http://www.orafaq.com/papers/locking.pdf