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.
Figure 1 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. Figure 1. Example of byte-range locking
