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 LOCKTABLE for that purpose rather than changing the setting of this parameter from its default setting of ALWAYS.