IQGOVERN_PRIORITY_TIME Option

Limits the time a high priority query waits in the queue before starting.

Allowed Values

0 – 1,000,000 seconds. Must be lower than IQGOVERN_MAX_PRIORITY.

Default

0 (disabled)

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Remarks

Limits the time a high priority (priority 1) query waits in the queue before starting. When the limit is reached, the query is started even if it exceeds the number of queries allowed by the -iqgovern setting. The range is from 1 to 1,000,000 seconds. The default (0) disables this feature. IQGOVERN_PRIORITY_TIME must be set PUBLIC.