互联网服务
exec时间很高，但cpu极低，请教下是什么原因
请教一下，exec时间很高，但系统无死锁，锁等数量其实也正常，cpu使用率也一般，那会的有什么原因？个人觉得IO这样的可能是个原因，那么我如何确定是不是IO的问题呢？平时系统的IO其实负载很低，但是不排除特定时间并发上来后IO有问题，有什么办法去监控吗？TOTAL_EXEC_TIMETOTAL_EXEC_TIME_PE...显示全部
查看其它 3 个回答drdb2的回答
total_exec_time is not always a reliable measure.
Please read this page
http://pic.dhe.ibm.com/infocente ... 520.html&lang%3Dsl.
"
Note: Due to the differences in granularity with which the DB2 system collects statistics, the value of the total_exec_time monitor element might not equal the sum of values of system_cpu_time and user_cpu_time monitor elements. In this case, the sum of system_cpu_time and user_cpu_time monitor elements more accurately reflects the actual total execution time.
"
Please read this page
http://pic.dhe.ibm.com/infocente ... 520.html&lang%3Dsl.
"
Note: Due to the differences in granularity with which the DB2 system collects statistics, the value of the total_exec_time monitor element might not equal the sum of values of system_cpu_time and user_cpu_time monitor elements. In this case, the sum of system_cpu_time and user_cpu_time monitor elements more accurately reflects the actual total execution time.
"
浏览413