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.