WSTATS configuration parameter
Use the WSTATS configuration parameter to specify whether the onstat -g wst command displays wait statistics for threads within the system.
Attention: You should expect a small performance impact
due to the cost of gathering statistical information. Enabling the
WSTATS configuration parameter for production systems is not recommended.
- onconfig.std value
- WSTATS 0
- range of values
- 0 = Disable wait statistics
1 = Enable wait statistics
- takes effect
- After you edit your onconfig file and restart the database server.
- When you reset the value dynamically in your onconfig file by running the onmode -wf command.
- When you reset the value in memory by running the onmode -wm command.