|
Snapshot Level Application |
Logical Data Grouping appl |
Monitor Switch Basic |
|
Resettable |
Yes |
|
|
Element Name Element Type |
agent_usr_cpu_time time |
Description: The total CPU time (in seconds and microseconds) used by database manager agent process.
Usage: This element along with the other CPU-time related elements can help you identify applications or queries that consume large amounts of CPU.
This counter includes time spent on both SQL and non-SQL statements, as well as any fenced user defined functions (UDF) or stored procedures executed by the application.
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 returned as 0. For example, they are not available on OS/2. |