The total time spent executing routines. The value is given in milliseconds.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
Activities | event_activitymetrics | ACTIVITY METRICS BASE |
Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
Statistics | event_scmetrics* | REQUEST METRICS BASE |
Statistics | event_wlmetrics* | REQUEST METRICS BASE |
* When returned as part of this logical data group, this element reflects the change in value of this metric since the last statistics collection or database activation, whichever was more recent. |
If the collection level is set to BASE, then the value of total_routine_time monitor element does not include any time spent executing functions that were defined using the NO SQL clause.
If the collection level is set to EXTENDED, then the value of total_routine_time monitor element includes the time spent in all routines.