Use Nap Maximum (-napmax) to specify the maximum time (in milliseconds) to sleep (nap) after the -spin value is exhausted due to failure to acquire a latch.

For Enterprise database licenses only.

n

The maximum time (in milliseconds) to sleep (nap).

Increasing the value of -napmax can decrease CPU utilization, and can decrease individual user performance while improving performance of the overall system.

Testing by Progress Software has determined that 250 milliseconds is a good default. Changing the value of -napmax away from the default is not recommended.

The length of a nap starts with the value specified by -nap and increases until -napmax is reached.

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.

For more information see:

• Spin Lock Retries (-spin)
• Nap Time (-nap)