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 |