The database server uses one of the following granularity levels for locking smart large objects:
The default locking granularity is at the level of the smart large object. In other words, when you update a smart large object, by default the database server locks the smart large object that is being updated.
Locks on the sbspace chunk header partition only occur when the database server promotes locks on smart large objects. For more information, see Lock Promotion.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]