Locks for Smart Large Objects

Smart large objects have several unique locking behaviors because their columns are typically much larger than other columns in a table. This section discusses the following unique behaviors:

• Types of locks on smart large objects
• Byte-range locking
• Lock promotion
• Dirty Read isolation level with smart large objects