Operating system and syntax UNIX / Windows 
-spinPause n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 64 0 1 1
n

The maximum number of pause instructions allowed when a process waits for a lock.

The spinPause parameter (-spinPause) reduces CPU overhead during spin-lock contention by inserting pause instructions into spin loops. This is useful on multi-core systems where excessive spinning increases memory bus contention.

If the value of n is zero (0), a process will spin continuously until reaching the spin retry limit, specified by the -spin parameter. When -spinPause is set to a value greater than 0, the number of pause instructions doubles with each spin iteration, up to the configured maximum level. After the process naps and resumes, the backoff count resets to 1 for the next spin cycle.

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.