lock shared memory

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Static

Display level

Comprehensive

Required role

System administrator

Configuration group

Physical Memory

lock shared memory disallows swapping of Adaptive Server pages to disk and allows the operating system kernel to avoid the server’s internal page locking code. This can reduce disk reads, which are expensive.

Not all platforms support shared memory locking. Even if your platform does, lock shared memory may fail due to incorrectly set permissions, insufficient physical memory, or for other reasons. See operating system documentation for your platform for information on shared memory locking.