lock granularity
Set the amount of data actually locked out for other users when issuing a lock.
USYS$MSS_PARAMS = lock granularity : page | table |
row
USYS$MSS_PARAMS = gran : page | table | row
Description
The smaller the locked amount, the greater the concurrency that can be achieved, at a cost of more overhead in maintaining locks.