Byte-range locking
Rather than locking the entire smart large object, you can lock only a specific byte range of a smart large object.
Byte-range locking is advantageous because it allows multiple users to update the same smart large object simultaneously, as long as they are updating different parts of it. Also, users can read a part of a smart large object while another user is updating or reading a different part of the same smart large object.
Example of byte-range locking shows two locks
placed on a single smart large object. The first lock is on bytes
2, 3, and 4. The second lock is on byte 6 alone.