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.