The total user CPU time (in seconds and microseconds) used by the database manager agent process, the unit of work, or the statement. For event monitors that write to tables, the value of this element is given in microseconds by using the BIGINT data type.
When either the statement monitor switch or the timestamp switch is not turned on, this element is not collected and -1 is written instead.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Connection | event_conn | - |
Transactions | event_xact | - |
Statements | event_stmt | - |
Activities | event_activity | - |
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.