MaxWaitForQuietPoint

Integer

5

Purpose

The MaxWaitForQuietPoint parameter specifies the maximum time in seconds that the database waits for a quietpoint in the following situations.

If the performing of one of these operations does not correspond to a natural quietpoint, the MaxWaitForQuietPoint parameter specifies the maximum time in seconds that the database waits for existing transactions to complete before performing the operation after temporarily suspending new transactions from starting.

If a quietpoint is not achieved within the time specified in this parameter, a DB_QUIETPOINT_TIMEOUT exception is raised.

The minimum value is zero (0) and the maximum value is 600 seconds (10 minutes).

For more details, see "Quietpoints and Long Transactions", in Chapter 3 of the Database Administration Guide.

Parameter is read when …

The database server node is initialized; for example, when you restart the database server.

Hint

The default value of zero (0) causes database operations requiring a quietpoint to fail when database transactions are in progress.