ChannelDB2

Alessandro Oppici's Blog (1)

Service class time component

Hi everyone,

In order to analize system performance I tried to discover how time is spent within my database system.

According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.

By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.

It seems that with "normal" DML statements these two values are quite…

Continue

Added by Alessandro Oppici on April 24, 2016 at 2:58am — No Comments

Latest Blog Posts

Most Popular Blog Posts

Monthly Archives

2016

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service