December 2002
Intermediate to advanced
928 pages
85h 29m
English
SPIN_COUNT
Value: 1-1000000
Default: 1
Specifies the number of times a process will request a latch until it obtains one. If the number of requests reaches SPIN_COUNT, the process fails to acquire the latch, sleeps, and then tries to acquire the latch again. Because a latch is a low-level lock, a process does not hold it long, and it is less expensive to use CPU time by spinning a process than it is to make a process sleep. Obsolete with Oracle8i.