W

wl_work_action_set_id - Workload work action set identifier monitor element

If this activity has been categorized into a work class of workload scope, this monitor element shows the ID of the work action set associated with the work class set to which the work class belongs. Otherwise, this monitor element shows the value of 0.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected

Usage

Use this monitor element, together with the wl_work_class_id monitor element, to uniquely identify the workload work class of the activity, if one exists.

wl_work_class_id - Workload work class identifier monitor element

If this activity has been categorized into a work class of workload scope, then this monitor element displays the identifier of the work class. Otherwise, this monitor element displays the value of 0.

Table 3. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	Always collected

Table 4. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	Always collected

Usage

Use this monitor element, together with the wl_work_action_set_id monitor element, to uniquely identify the workload work class of the activity, if one exists.

wlm_queue_assignments_total - Workload manager total queue assignments monitor element

The number of times that activities or connections have been queued by a WLM threshold.

Table 5. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities	ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics	REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information	REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics	REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function	REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function	REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics	REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics	REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	ACTIVITY METRICS BASE

Table 6. Event Monitoring Information
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

wlm_queue_time_total - Workload manager total queue time monitor element

The time spent waiting on a WLM queuing threshold. This value is given in milliseconds.

Table 7. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY table function - Return a list of activities	ACTIVITY METRICS BASE
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics	REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_DATABASE table function - Get database level information	REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - Get database information metrics	REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	ACTIVITY METRICS BASE
MON_GET_ROUTINE - get aggregated execution metrics for routines table function	REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS - get aggregated execution metric details for routines table function	REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics	REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics	REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document)	REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities	ACTIVITY METRICS BASE

Table 8. Event Monitoring Information
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

wlo_completed_total - Workload occurrences completed total monitor element

The number of workload occurrences to complete since last reset.

Table 9. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_WORKLOAD_STATS table function - Return workload statistics	Always collected
WLM_GET_WORKLOAD_STATS table function - Return workload statistics	Always collected

Table 10. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_wlstats	Always collected

Usage

Use this element to determine how many occurrences of a given workload are driving work into the system.

work_action_set_id - Work action set ID monitor element

The ID of the work action set to which this statistics record applies.

Table 11. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_histogrambin	Always collected
Statistics	event_wcstats	Always collected

Usage

Use this element in conjunction with other activity history elements for analysis of the behavior of an activity or with other statistics elements for analysis of a work class.

The value of this element is 0 when the following conditions are met:

The element is reported in an event_histogrambin logical data group.
The histogram data is collected for an object that is not a work class.

work_action_set_name - Work action set name monitor element

The name of the work action set to which the statistics shown as part of this event are associated.

Table 12. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
MON_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics	Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics	Always collected

Table 13. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_qstats	Always collected
Statistics	event_wcstats	Always collected

Usage

Use this element along with the work_class_name element to uniquely identify the work class whose statistics are being shown in this record or to uniquely identify the work class which is the domain of the threshold queue whose statistics are shown in this record.

work_class_id - Work class ID monitor element

The identifier of the work class to which this statistics record applies.

Table 14. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_wcstats	Always collected
Statistics	event_histogrambin	Always collected

Usage

Use this element in conjunction with other statistics elements for analysis of a work class.

The value of this element is 0 when the following conditions are met:

The element is reported in an event_histogrambin logical data group.
The histogram data is collected for an object that is not a work class.

work_class_name - Work class name monitor element

The name of the work class to which the statistics shown as part of this event are associated.

Table 15. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
MON_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics	Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics	Always collected

Table 16. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statistics	event_qstats	Always collected
Statistics	event_wcstats	Always collected

Usage

Use this element along with the work_action_set_name element to uniquely identify the work class whose statistics are being shown in this record or to uniquely identify the work class which is the domain of the threshold queue whose statistics are shown in this record.

workload_id - Workload ID monitor element

An integer that uniquely identifies a workload.

Table 17. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_WORKLOAD table function - Get workload metrics	Always collected
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics	Always collected
MON_SAMPLE_WORKLOAD_METRICS - Get sample	Always collected

Table 18. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_info	Basic

Table 19. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	Always collected
Unit of work	-	Always collected
Activities	event_activity (reported in the details_xml document)	Always collected
Statistics	event_scstats (reported in the metrics document)	Always collected
Statistics	event_wlstats (reported in the metrics document)	Always collected
Unit of work	Reported in the system_metrics document.	Always collected
Statistics	event_wlstats	Always collected
Statistics	event_histogrambin	Always collected
Activities	event_activity	Always collected
Threshold violations	event_thresholdviolations	Always collected

Usage

Use this ID to uniquely identify the workload to which this activity, application, histogram bin, or workload statistics record belongs.

The value of this element is 0 when the following conditions are met:

The element is reported in an event_histogrambin logical data group.
The histogram data is collected for an object that is not a workload.

workload_name - Workload name monitor element

Name of the workload.

Table 20. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_FORMAT_LOCK_NAME table function - Format the internal lock name and return details	Always collected
MON_GET_AGENT table function - List agents, fenced mode processes, and system entities for the database	Always collected
MON_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics	Always collected
MON_GET_WORKLOAD table function - Get workload metrics	Always collected
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics	Always collected
MON_GET_WORKLOAD_STATS table function - Return workload statistics	Always collected
MON_SAMPLE_WORKLOAD_METRICS - Get sample	Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics	Always collected
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class	Always collected
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences	Always collected
WLM_GET_WORKLOAD_STATS table function - Return workload statistics	Always collected

Table 21. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	Always collected
Unit of work	-	Always collected
Activities	event_activity (reported in the details_xml document)	Always collected
Statistics	event_scstats (reported in the metrics document)	Always collected
Statistics	event_wlstats (reported in the metrics document)	Always collected
Unit of work	Reported in the system_metrics document.	Always collected
Statistics	event_wlstats	Always collected

Usage

In the statistics event monitor and workload table functions, the workload name identifies the workload for which statistics or metrics are being collected and reported. In the unit of work event monitor and unit of work table functions, the workload name identifies the workload that the unit of work was associated with.

Use the workload name to identify units of work or sets of information that apply to a particular workload of interest.

workload_occurrence_id - Workload occurrence identifier monitor element

The ID of the workload occurrence to which this activity belongs.

Table 22. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_AGENT table function - List agents, fenced mode processes, and system entities for the database	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics	Always collected
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class	Always collected
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences	Always collected

Table 23. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Unit of work	-	Always collected
Activities	event_activity	Always collected

Usage

Use this to identify the workload occurrence that submitted the activity.

workload_occurrence_state - Workload occurrence state monitor element

The state of the workload occurrence.

Table 24. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_CONNECTION table function - Get connection metrics	Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document)	Always collected
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences	Always collected

Usage

Possible values include:

DECOUPLED: Workload occurrence does not have a coordinator agent assigned (concentrator case).
DISCONNECTPEND: Workload occurrence is disconnecting from the database.
FORCED: Workload occurrence has been forced.
INTERRUPTED: Workload occurrence has been interrupted.
QUEUED: Workload occurrence coordinator agent is queued by a workload management queuing threshold. In a partitioned database environment, this state may indicate that the coordinator agent has made an RPC another member to obtain threshold tickets and has not yet received a response.
TRANSIENT: Workload occurrence has not yet been mapped to a service superclass.
UOWEXEC: Workload occurrence is processing a request.
UOWWAIT: Workload occurrence is waiting for a request from the client.