Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 182 of 220
ROW_LOCKING
specifies whether row locks are acquired during UPDATE
operations.
Values:
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
.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|