The system property determines
the threshold for number of rows touched for a particular table above which
the system will escalate to table-level locking. The default value of this
property is 5000. For large systems, set this property to a higher value.
For smaller systems, lower it.
This property also sets the threshold for transaction-based lock escalation
(see ).
For more
information about lock escalation, see .