Summary information |
|
---|---|
Default value |
0 (off) |
Valid values |
0 (off), 1(on) |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
read committed with lock determines whether an Adaptive Server using transaction isolation level 1 (read committed) holds shared locks on rows or pages of data-only-locked tables during select queries. For cursors, the option applies only to cursors declared as read-only. By default, this parameter is turned off to reduce lock contention and blocking. This parameter affects only queries on data-only locked tables.
For transaction isolation level 1, select queries on allpages-locked tables continue to hold locks on the page at the current position. Any updatable cursor on a data-only-locked table also holds locks on the current page or row. See the Performance and Tuning Guide for more information.