|
Snapshot Level Application |
Logical Data Grouping appl stmt |
Monitor Switch Statement Statement |
|
Resettable |
No |
|
|
Element Name Element Type |
stmt_usr_cpu_time time |
Description: The total user CPU time (in seconds and microseconds) used by the currently executing statement.
Usage: This element along with the other related CPU-time elements can help you understand the level of activity within an application, and can help you identify applications that could benefit from additional tuning.
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 set to 0. For example, it is not available for OS/2. |