The total system CPU
time (in seconds and
microseconds) used by the database
manager agent
process.
- Element identifier
- agent_sys_cpu_time
- Element type
- time
Table 1. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Application |
appl |
Timestamp |
For snapshot monitoring at the application
level, this counter can
be reset. This counter cannot be reset at other levels.
- 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.
This
element includes CPU time for both SQL and non-SQL statements, as
well as
CPU time for any unfenced 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.