System CPU Time used by Agent



Snapshot Level
Application


Logical Data Grouping
appl


Monitor Switch
Basic


Resettable


Yes


 


Element Name
Element Type



agent_sys_cpu_time
time

 

Description:  The total system CPU time (in seconds and microseconds) used by the database manager agent process.

Usage:  This element along with the other related CPU-time elements can help you understand the level of activity within an application, and may help you identify applications that could benefit from additional tuning.

It includes CPU time for both SQL and non-SQL statements, as well as CPU time for any fenced User Defined Functions (UDFs)

System CPU represents the time spent in system calls. User CPU represents time spent executing database manager code.
Note:If this information is not available for your operating system, this element will be set to 0. For example, it is not available for OS/2.