String 

ROW_LOCKING = {ALWAYS | DEFAULT | INTENT} 

Static 

ALWAYS 

You must set this parameter for every instance, and multiple instances must have the same value. 

ROW_LOCKING specifies whether row locks are acquired during UPDATE operations.

• ALWAYS and DEFAULT: Row locks are acquired. Table locks are not acquired.

• INTENT: In addition to row locks, restricted table-level locks are acquired during UPDATE operations.

The acquisition of table-level locks is a way to ensure data concurrency. However, Oracle Corporation recommends that you use the SQL statement LOCK TABLE for that purpose rather than changing the setting of this parameter from its default setting of ALWAYS.