How can I use the statistics collected by either the QSTATS or WSTATS parameters (see onstat -g wst and onstat -g ost) to find bottlenecks in my system?
Set WSTAT to 1 in your ONCONFIG file, restart the server, and run the following query at frequent intervals during heavy loads:
select sum(cumtime) , reason from sysseswts where reason != "condition" and cumtime > 1000 group by reason order by 1 desc
3.145.60.166