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