Reading notes from Oracle Database Transactions and Locking Revealed by Tom Kyte and Darl Kuhn (2014).