Progress
Database Administration
Guide and Reference


Spin Locks

On multi-processor shared-memory systems, the database engine uses a spin lock algorithm to control access to shared-memory structures. The spin lock algorithm works as follows: When a process needs a shared-memory resource, it attempts to acquire the resource’s latch. If it cannot acquire the resource’s latch it repeats the attempt. This iterative process is called spinning. If a process fails to acquire a latch after a specified number of spins, the process pauses, or takes a nap, before trying again. If a process repeatedly fails to acquire a latch, the length of its nap is gradually increased. You can set the Spin Lock Tries (-spin) parameter to specify how many times to test a lock before napping.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095