Name
SPIN_COUNT
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.