Wait Events

enable_instr_track_wait

Parameter description: Specifies whether to enable real-time collection of wait event information.

In the x86-based centralized deployment scenario, the hardware configuration specifications are 32-core CPU and 256 GB memory. When the Benchmark SQL 5.0 tool is used to test performance, the performance fluctuates by about 1.4% by enabling or disabling this parameter.

Parameter type: Boolean.

Unit: none

Value range:

• on indicates that the function of collecting wait event information is enabled.
• off indicates that the function of collecting wait event information is disabled.

Default value: on

Setting method: This is a SIGHUP parameter. Set it based on instructions provided in Table 1.

Setting suggestion: You are advised to set it to on.

Risks and impacts of improper settings: If this parameter is disabled, wait events cannot be collected in real time, which makes it difficult to locate faults in a timely manner.