edu_ID - Engine dispatchable unit ID monitor element

ID of engine dispatchable unit with which this memory pool is associated.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function - Return Db2® engine dispatchable units system information Always collected
MON_GET_LATCH table function - List all latches in the current member Always collected
MON_GET_MEMORY_POOL table function - Get memory pool information Always collected
PD_GET_DIAG_HIST table function - Return records from a given facility Always collected

Usage

When returned by the table function MON_GET_MEMORY_POOL, this monitor element is NULL except when the memory pool being described is PRIVATE.

EFF_PARALLELISM - The effective parallelism monitor element

The total effective_query_degree across all activities in this service subclass, superclass, or workload.

Table 3. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_WORKLOAD table function - Get workload metrics Always collected
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service superclass metrics REQUEST METRICS BASE
Table 4. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected
Statistics event_superclassstats Always collected
Statistics event_wlstats Always collected

EFF_PARALLELISM_AVG - The average effective parallelism monitor element

The average effective_query_degree for all activities in this service subclass, superclass, or workload.

Table 5. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_WORKLOAD_STATS table function - Return workload statistics Always collected
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 6. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected
Statistics event_superclassstats Always collected
Statistics event_wlstats Always collected

EFF_PARALLELISM_TOP - The top effective parallelism monitor element

The peak effective_query_degree for an individual activity across all activities in this service subclass, superclass, or workload.

Table 7. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_WORKLOAD_STATS table function - Return workload statistics Always collected
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
Table 8. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scstats Always collected
Statistics event_superclassstats Always collected
Statistics event_superclassstats Always collected
Statistics event_wlstats Always collected

eff_stmt_text - Effective statement text monitor element

The effective text of the SQL statement, if the statement was modified as a result of the statement concentrator.

Table 9. 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 10. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activity event_activitystmt Always collected

Usage

If the statement concentrator is enabled and if the statement text has been modified as a result of the statement concentrator, then this monitor element contains the effective statement text. Otherwise, this monitor element contains a text string which is 0 bytes long.

effective_isolation - Effective isolation monitor element

The effective isolation level for this statement.

Table 11. 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
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries Always collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always collected
Table 12. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - Always collected
Package cache - Always collected

Usage

Use this element to understand the isolation level that was used during the execution of the statement. This element is only applicable for SQL statements that are executing, however, monitor interfaces like the locking event monitor can include this element for statements that are compiling. When statements are compiling, the isolation level is not applicable and the monitor element reports a value of N, meaning none. During the compilation process, Db2 makes it's own selection of isolation level for internal catalog table scans to ensure integrity of the compiled statement and does not respect the current isolation level that is set by the user.

effective_lock_timeout - Effective lock timeout monitor element

The effective lock timeout value for this activity. This value is reported in seconds.

Table 13. 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

effective_query_degree - Effective query degree monitor element

The effective query degree of parallelism for this activity.

Table 14. 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

MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities

Always Collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always collected
Table 15. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - Always collected

ehl_lockwait_time - Total time for EHL object lock wait monitor element

During extent movement, this monitor element shows the overall time taken to acquire the Explicit Hierarchical Locking (EHL) table lock.

The EHL table lock is required to switch the object out of the NOT_SHARED state, if applicable. The value is given in milliseconds.

Table 16. Table function monitoring information
Table function Monitor element collection level
MON_GET_EXTENT_MOVEMENT_STATUS - get extent movement progress Always collected

elapsed_exec_time - Statement Execution Elapsed Time monitor element

At the DCS statement level, this is the elapsed time spent processing an SQL request on a host database server. This value is reported by this server. For event monitors that write to tables, the value of this element is given in microseconds by using the BIGINT data type. In contrast to the host_response_time element, this element does not include the network elapsed time between Db2 Connect and the host database server. At other levels, this value represents the sum of the host execution times for all the statements that were executed for a particular database or application, or for those statements that used a given number of data transmissions.
Table 17. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Statement, Timestamp
Application appl Statement, Timestamp
DCS Database
  • dcs_dbase
  • stmt_transmissions
 Statement, Timestamp
DCS Application
  • dcs_appl
  • stmt_transmissions
 Statement, Timestamp
DCS Statement dcs_stmt Statement, Timestamp
For snapshot monitoring at the statement level, this counter cannot be reset. This counter can be reset at other levels.
Usage
Use this element, along with other elapsed time monitor elements, to evaluate the database server's processing of SQL requests and to help isolate performance issues.
Subtract this element from the host_response_time element to calculate the network elapsed time between Db2 Connect and the host database server.
Note: For the dcs_dbase, dcs_appl, dcs_stmt and stmt_transmissions levels, the elapsed_exec_time element applies only to z/OS® databases. If the Db2 Connect gateway is connecting to a Windows, Linux®, AIX®, or other UNIX database, the elapsed_exec_time is reported as zero.

entry_time - Entry time monitor element

The time at which this activity entered the system.

Table 20. 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

Usage

estimated_cpu_entitlement - Estimated CPU entitlement monitor element

The percentage of total CPU on a host or an LPAR that a service subclass is configured to consume based on its CPU shares assuming that it consumes no more and no less than what it is configured to consume. The determination of which service classes participate in its calculation is based on the actual CPU utilization measured over the sampling period versus the WLM_DISP_MIN_UTIL database manager configuration setting. The impact of a CPU limit on a service class itself, on the service classes with which it competes, or on a parent service class (if it has one) are not taken into account in the calculation.
Table 21. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_SAMPLE_SERVICE_CLASS_METRICS - Get sample service class metrics Always collected

estimated_util_heap_top - estimated peak utility heap monitor element

Estimated peak utility heap memory usage for the query.

Note: This monitor element is available in Db2version 11.5.4 and later.
Table 22. Table function monitoring information
Table function Monitor element collection level

MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities

Always Collected
Table 23. Event monitoring information
Event type Logical data grouping Monitor switch
Activity event_activity Always collected
Package cache pkgcache Always collected

estimated_runtime - Estimated execution time for a DML statement monitor element

The estimated execution time for a DML statement. This value is impacted by system and database usage. The estimate does not include any time spent outside query execution (for example, prepare time, queue time or client time). A NULL value will be reported for any non-DML statements (such as CALL or DDL), or if an estimate is not available. The value is given in microseconds.

Table 24. 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 Always Collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always Collected
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries Always Collected

MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities

Always Collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always Collected
Table 25. Event monitoring information
Event type Logical data grouping Monitor switch
Activity event_activity Always collected
Package Cache pkgcache Always collected

estimated_sort_consumers_top - Estimated concurrently executing sort memory consumers monitor element

Estimate of the highest number of sort memory consumers that will be active concurrently during execution of an activity.

Table 26. 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 Always Collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always Collected
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries Always Collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always Collected
Table 27. Event monitoring information
Event type Logical data grouping Monitor switch
Activity event_activity Always collected
Package cache pkgcache Always collected

estimated_sort_shrheap_top - Estimated shared sort heap consumption monitor element

Estimate of the shared sort memory that will be used during execution of an activity, in 4 KB pages. If shared sort memory is not enabled, the estimated_sort_shrheap_top monitor element will be reported as 0.

Table 28. 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 Always Collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always Collected
MON_GET_PKG_CACHE_STMT_DETAILS - Get detailed metrics for package cache entries Always Collected

MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities

Always Collected
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities Always Collected
Table 29. Event monitoring information
Event type Logical data grouping Monitor switch
Activity event_activity Always collected
Package cache pkgcache Always collected

estimatedsqlcost_threshold_id - Estimated SQL cost threshold ID monitor element

The ID of the ESTIMATEDSQLCOST threshold that was applied to the activity.

Table 30. 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

Usage

Use this element to understand which ESTIMATEDSQLCOST threshold, if any, was applied to the activity.

estimatedsqlcost_threshold_value - Estimated SQL cost threshold value monitor element

The upper bound of the ESTIMATEDSQLCOST threshold that was applied to the activity.

Table 31. 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

Usage

Use this element to understand the value of the ESTIMATEDSQLCOST threshold applied to the activity, if any.

estimatedsqlcost_threshold_violated - Estimated SQL cost threshold violated monitor element

This monitor element returns '1’ (Yes) to indicate that the activity violated the ESTIMATEDSQLCOST threshold. ’0’ (No) indicates that the activity has not yet violated the threshold.

Table 32. 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

Usage

Use this element to determine if the activity violated the ESTIMATEDSQLCOST threshold that was applied to the activity.

event_id - Event ID monitor element

An identifier associated with an event that is used in conjunction with other monitor elements to uniquely identify the event. This monitor element forms a part of the xmlid monitor element in the interfaces that return that element.

Table 33. Event Monitoring Information
Event Type Logical Data Grouping Monitor Element Collection Level
Change History changesummary
dbdbmcfg
ddlstmtexec
evmonstart
regvar
txncompletion
utillocation
utilphase
utilstart
utilstop		 Always collected
Locking
  • event_lock
  • event_lock_participants
  • event_lock_participants_activities
  • event_lock_activity_values
 Always collected
Package Cache
  • event_pkgcache
  • event_pkgcache_metrics
  • event_pkgcache_stmt_args
 Always collected
Unit of Work event_uow Always collected

Usage

The value for this identifier is different depending on the type of event record in which it appears:
Locking event monitor records
An numeric identifier for the event. The ID is recycled at database activation time. Uniqueness is guaranteed by the combination of event_timestamp, event_id, member, and event-type.
Unit of work event monitor records
An alias of the UOW ID that is unique per connection. Uniqueness is guaranteed by the combination of event_timestamp, event_id, event-type, member, and appl_id.
Package cache event monitor record
An numeric identifier for the event. The ID is recycled at database activation time. Uniqueness is guaranteed by the combination of event_timestamp, event_id, member, and event-type.
Change history event monitor record
An numeric identifier for the event. The ID is recycled at database activation time. The uniqueness of events is guaranteed by the combination of event_timestamp, event_id, member, and event-type.

event_monitor_name - Event Monitor Name monitor element

The name of the event monitor that created the event data stream.

Element identifier
event_monitor_name
Element type
information
Table 34. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Event Log Header event_log_header Always collected
Usage
This element allows you to correlate the data that you are analyzing to a specific event monitor in the system catalog tables. This is the same name that can be found in the NAME column of the SYSCAT.EVENTMONITORS catalog table, which is the name specified on the CREATE EVENT MONITOR and SET EVENT MONITOR statements.

event_time - Event Time monitor element

The date and time an event occurred.

Table 35. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Tablespaces event_tablespace -
Tables event_table -
Usage
You can use this element to help relate events chronologically.

event_timestamp - Event timestamp monitor element

The time that this event record was generated by the database manager.

Table 36. Event Monitoring Information
Event Type Logical Data Grouping Monitor Element Collection Level
Activity
  • event_activity
  • event_activitystmt
  • event_activityvals
  • event_activitymetrics
 Always collected
Change History changesummary
dbdbmcfg
ddlstmtexec
evmonstart
regvar
txncompletion
utillocation
utilphase
utilstart
utilstop		 Always collected
Locking
  • event_lock
  • event_lock_participants
  • event_lock_participants_activities
  • event_lock_activity_values
 Always collected
Package Cache
  • event_pkgcache
  • event_pkgcache_metrics
  • event_pkgcache_stmt_args
 Always collected
Unit of Work
  • event_uow
 Always collected
     

event_type - Event Type monitor element

The event type of the event that is being reported. Reported by the change history, locking, and package cache event monitors only.

Many even monitors capture only one type of event. For example, a unit of work event monitor records a unit of work completion event that captures data related to the unit of work when it is completed. Other event monitors, such as the database, table, buffer pool or table space event monitors each capture one type of event after database deactivation.

Some event monitors, however, generate different types of events. These event monitors report the type of event in the event_type monitor element. Table 37 shows the event monitors that return this monitor element. Table 38 shows the possible values that this monitor element can have.
Table 37. Event Monitoring Information
Event Monitor Logical Data Grouping Monitor Element Collection Level
Change History changesummary
dbdbmcfg
ddlstmtexec
evmonstart
regvar
txncompletion
utillocation
utilphase
utilstart
utilstop		 Always collected
Locking
  • event_lock
  • event_lock_participants
  • event_lock_participants_activities
  • event_lock_activity_values
 Always collected
Unit of work Not applicable. For more information, see the usage notes for this event monitor in Table 38. Always collected
Package cache
  • pkgcache
 Always collected
Table 38. Possible values for event_type
Event monitor Possible values for event_type element Usage notes
Change history
  • DBCFG
  • DBCFGVALUES
  • DBMCFG
  • DBMCFGVALUES
  • REGVAR
  • REGVARVALUES
  • DDLSTMTEXEC
  • TXNCOMPLETION
  • EVMONSTART
  • UTILSTART
  • UTILSTOP
  • UTILSTARTPROC
  • UTILSTOPPROC
  • UTILPHASESTART
  • UTILPHASESTOP
 The event_type monitor element is included as a column in the output of this event monitor.
Locking
  • LOCKTIMEOUT
  • LOCKWAIT
  • DEADLOCK
 The event_type monitor element is included as a column in the output of this event monitor when it writes to either regular or unformatted event (UE) tables. It is also included in the output created by the routines EVMON_FORMAT_UE_TO_TABLES or EVMON_FORMAT_UE_TO_XML.
Package cache
  • PKGCACHEBASE
  • PKGCACHEDETAILED
 The event_type monitor element is included as a column in the output of this event monitor when it writes to unformatted event (UE) tables, but not regular tables. It is also included in the output created by the routines EVMON_FORMAT_UE_TO_TABLES or EVMON_FORMAT_UE_TO_XML.
Unit of work
  • UOW
 The event_type monitor element is included as a column in the output of this event monitor only when it writes to an unformatted event (UE) table. Moreover, it is included only in the UE table created by this event monitor; it is not included in the output created by the routines EVMON_FORMAT_UE_TO_TABLES or EVMON_FORMAT_UE_TO_XML.

evmon_activates - Number of event monitor activations monitor element

The number of times an event monitor has been activated.

Element identifier
evmon_activates
Element type
counter
This monitor element is not reported by all event monitors. See Table 39 for more details.
Table 39. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Tables event_table Always collected
Tablespaces event_tablespace Always collected
Bufferpools event_bufferpool Always collected
Deadlocks event_deadlock Always collected
Deadlocks event_dlconn Always collected
Deadlocks with Details event_detailed_dlconn Always collected
Statements event_stmt_history Always collected
Connections* -  
Transactions* -  
Statistics* -  
Threshold violations* -  

* This event monitor updates the evmon_activates column only in the catalog table SYSCAT.EVENTMONITORS. The monitor element is not included in any of the logical data groups that are written to event monitor output tables.
Usage
Use this element to correlate information returned by the event monitors listed in Table 39. This element is applicable only to write-to-table event monitors; it is not maintained for event monitors that write to a file or pipe.
All of the event monitors in Table 39 update the evmon_activates column of the SYSCAT.EVENTMONITORS catalog table when the event monitor is activated. This change is logged, so the DATABASE CONFIGURATION displays: 
All committed transactions have been written to disk = NO
If an event monitor is created with the AUTOSTART option, and the first user CONNECTS to the database and immediately DISCONNECTS so that the database is deactivated, a log file is produced.

Unless otherwise noted, these event monitors also include the value for evmon_activates as a column in the tables to which event data is written.

Event monitors not included in this table do not report the evmon_activates monitor element.

evmon_flushes - Number of Event Monitor Flushes monitor element

The number of times the FLUSH EVENT MONITOR SQL statement has been issued.

Element identifier
evmon_flushes
Element type
information
Table 40. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db Always collected
Tables event_table Always collected
Tablespaces event_tablespace Always collected
Bufferpools event_bufferpool Always collected
Usage
This identifier increments with each successive FLUSH EVENT MONITOR SQL request processed by the database manager after an application has connected to the database. This element helps to uniquely identify database, table, table space and buffer pool data.

evmon_wait_time - Event monitor wait time monitor element

The amount of time that an agent waited for an event monitor record to become available.

A wait occurs when the agent tries to write an event monitor record and the agent is blocked until a fast writer record becomes available. Fast writers are used for high volume, parallel writing of event monitor data to tables, files, or pipes.

The unit of measurement is milliseconds.

Table 41. 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 ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics 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 (reported in the DETAILS XML document) 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 REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_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 the 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 REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 42. Event Monitoring Information
Event Type Event monitor output type Logical Data Grouping Monitor Switch
Unit of work TABLE uow_metrics REQUEST METRICS BASE
Unit of work UE TABLE, processed by the EVMON_FORMAT_UE_TO_XML function Reported in the system_metrics document Always collected REQUEST METRICS BASE
Unit of work UE TABLE, processed by the EVMON_FORMAT_UE_TO_TABLES function Reported in the metrics document of the UOW_EVENT table and in the UOW_METRICS tableAlways collected REQUEST METRICS BASE
Package cache TABLE pkgcache_metrics ACTIVITY METRICS BASE
Package cache UE TABLE, processed by the EVMON_FORMAT_UE_TO_XML function Reported in the activity_metrics document Always collected ACTIVITY METRICS BASE
Package cache UE TABLE, processed by the EVMON_FORMAT_UE_TO_TABLES function Reported in the metrics document of the PKGCACHE_EVENT table and in the PKGCACHE_METRICS table Always collected ACTIVITY METRICS BASE
Activities TABLE, FILE, PIPE event_activitymetrics ACTIVITY METRICS BASE
Activities TABLE, FILE, PIPE event_activity (reported in the DETAILS XML document) ACTIVITY METRICS BASE
Statistics TABLE, FILE, PIPE event_scstats (reported in the DETAILS XML document) REQUEST METRICS BASE
Statistics TABLE, FILE, PIPE event_superclassstats (reported in the DETAILS XML document) REQUEST METRICS BASE
Statistics TABLE, FILE, PIPE event_wlstats (reported in the DETAILS XML document) REQUEST METRICS BASE

evmon_waits_total - Event monitor total waits monitor element

The number of times that an agent waited for an event monitor record to become available.

A wait occurs when the agent tries to write an event monitor record and the agent is blocked until a fast writer record becomes available. Fast writers are used for high volume, parallel writing of event monitor data to tables, files, or pipes.

Table 43. 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 ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics 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 (reported in DETAILS XML document) 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 REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_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 the 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 REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities ACTIVITY METRICS BASE
Table 44. Event Monitoring Information
Event Type Event monitor output type Logical Data Grouping Monitor Switch
Unit of work TABLE uow_metrics REQUEST METRICS BASE
Unit of work UE TABLE, processed by the EVMON_FORMAT_UE_TO_XML function Reported in the system_metrics documentAlways collected REQUEST METRICS BASE
Unit of work UE TABLE, processed by the EVMON_FORMAT_UE_TO_TABLES function Reported in the metrics document of the UOW_EVENT table and in the UOW_METRICS tableAlways collected REQUEST METRICS BASE
Package cache TABLE pkgcache_metrics ACTIVITY METRICS BASE
Package cache UE TABLE, processed by the EVMON_FORMAT_UE_TO_XML function Reported in the activity_metrics document Always collected ACTIVITY METRICS BASE
Package cache UE TABLE, processed by the EVMON_FORMAT_UE_TO_TABLES function Reported in the metrics document of the PKGCACHE_EVENT table and in the PKGCACHE_METRICS table Always collected ACTIVITY METRICS BASE
Activities TABLE event_activitymetrics ACTIVITY METRICS BASE
Activities TABLE event_activity (reported in the DETAILS_XML document) ACTIVITY METRICS BASE
Statistics TABLE event_scstats (reported in the DETAILS_XML document) REQUEST METRICS BASE
Statistics TABLE event_superclassstats (reported in the DETAILS_XML document) REQUEST METRICS BASE
Statistics TABLE event_wlstats (reported in the DETAILS_XML document) REQUEST METRICS BASE

exec_list_cleanup_time - Execution list cleanup time monitor element

Time when the execution list was last pruned.

This element returns NULL if execution list was never pruned.
Table 45. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected

Usage

A routine execution list is a list of all statements (sections) that are executed by an invoked procedure, external function, compiled function, compiled trigger, or anonymous block. Section information appears in the routine execution list if you set the value of the mon_rtn_execlist configuration parameter to ON.

Routine execution list data cannot use more than 20% of the available monitor heap. If the value of the mon_heap_sz configuration parameter is set to AUTOMATIC, the routine execution list data can take up to 20% of the value of the instance_memory configuration parameter.

Regular pruning is expected for databases with workloads that invoke many complex procedures and for databases where multiple features that use the monitor heap are enabled. If the value of the exec_list_cleanup_time configuration parameter is being updated too frequently, ensure that the values of the mon_heap_sz and the instance_memory database configuration parameters are AUTOMATIC, or increase the value of the mon_heap_sz configuration parameter.

exec_list_mem_exceeded - Execution list memory exceeded monitor element

Identifies if there was insufficient memory in the monitor heap to capture all statement information for the routine.

Possible values for this element are as follows:
Y
Insufficient memory to capture all statement information
N
For all other cases
The value is set to 'N' when the execution list for the routine is pruned.
Table 46. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected

Usage

This element is set to 'Y' when routine monitoring could not keep track of all the statements executed by the routine. This tracking inability can occur when the routine execution list data for the database reaches 20% of the available monitor heap or the monitor heap is full. In order for routine monitoring to maintain more entries in its execution list, you can increase the monitor heap size using the mon_heap_sz database configuration parameter, or set the mon_heap_sz and the instance_memory database configuration parameters to AUTOMATIC. If mon_heap_sz is already set to AUTOMATIC, you can increase the instance_memory configuration parameter.

executable_id - Executable ID monitor element

An opaque binary token generated on the data server that uniquely identifies the SQL statement section that was executed. For non-SQL activities, a 0-length string value is returned by event monitors and a NULL value is returned by table functions.

Table 47. 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) ACTIVITY METRICS BASE
MON_GET_AGENT table function - List agents, fenced mode processes, and system entities for the database Always collected
MON_GET_INDEX_USAGE_LIST table function - Returns information from an index usage list Always collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries ACTIVITY METRICS BASE
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list ACTIVITY METRICS BASE
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine ACTIVITY METRICS BASE
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class Always collected
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities Always collected
Table 48. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activity event_activitystmt Always collected
Package cache - Always collected

Usage

Use this monitor element as input to different monitoring interfaces to obtain data about the section. The MON_GET_PKG_CACHE_STMT table function, which is used to get SQL statement activity metrics in the package cache, takes the executable ID as input.

executable_list_size - Size of executable list monitor element

The number of entries that are present within the executable ID listing for a particular unit of work.

Table 49. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Unit of Work uow  

executable_list_truncated - Executable list truncated monitor element

Indicates whether the executable list is truncated. Possible values are YES or NO. The list can be truncated if there is insufficient memory available to store the entire executable list during processing.

Table 50. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Unit of Work uow  

execution_id - User Login ID monitor element

The ID that the user specified when logging in to the operating system. This ID is distinct from auth_id, which the user specifies when connecting to the database.

Table 51. 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 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 REQUEST METRICS BASE
Table 52. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl_info Basic
Application appl Basic
DCS Application dcs_appl_info Basic
Table 53. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Connections event_connheader -
Usage
You can use this element to determine the operating system userid of the individual running the application that you are monitoring.
Note: Authorization IDs are truncated to 30 bytes (if they exceed that length), so execution IDs that begin with the same 30-byte strings have the same execution_id value.

ext_table_read_volume - Total data read by external table readers monitor element

The total volume of data read by the external table readers from physical devices such as hard disks and solid state drives (SSD). The value is given in bytes.

Table 54. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 55. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_recv_volume - Total data received from external table readers monitor element

The total volume of data received by the agent from the external table readers. The value is given in bytes.

Table 56. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 57. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_recv_wait_time - Total agent wait time for external table readers monitor element

The total amount of time that the agent spent waiting for the external table readers to read and process data from external tables. The value is given in milliseconds.

Table 58. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 59. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_recvs_total - Total row batches received from external table readers monitor element

The total number of row batches received by the agent from the external table readers.

Table 60. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 61. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_send_volume - Total data sent to external table writers monitor element

The total volume of data sent by the agent to the external table writers. The value is given in bytes.

Table 62. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 63. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_send_wait_time - Total agent wait time for external table writers monitor element

The total amount of time that the agent spent waiting for the sent data to be processed and written by the external table writers.

Table 64. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 65. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_sends_total - Total row batches sent to external table writers monitor element

The total number of row batches sent to the external table writers.

Table 66. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 67. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

ext_table_write_volume - Total data written by external table writers monitor element

The total volume of data written by the external table writers to physical devices such as hard disks and solid state drives (SSD). The value is given in bytes.

Table 68. 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 - return information about an activity as an XML document ACTIVITY METRICS BASE
MON_GET_CONNECTION table function - Get connection metrics REQUEST METRICS BASE
MON_GET_CONNECTION_DETAILS table function - Get connection metrics as an XML document REQUEST METRICS BASE
MON_GET_DATABASE table function - get database information metrics REQUEST METRICS BASE
MON_GET_DATABASE_DETAILS table function - get database information metrics as an XML document REQUEST METRICS BASE
MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document ACTIVITY METRICS BASE
MON_GET_ROUTINE table function - get aggregated routine execution metrics REQUEST METRICS BASE
MON_GET_ROUTINE_DETAILS table function - get aggregated routine execution metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get service subclass metrics as an XML document REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS table function - Get service subclass metrics REQUEST METRICS BASE
MON_GET_SERVICE_SUPERCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) REQUEST METRICS BASE
MON_GET_TABLE table function - get table metrics DATA OBJECT METRICS EXTENDED
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list DATA OBJECT METRICS EXTENDED
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics REQUEST METRICS BASE
MON_GET_UNIT_OF_WORK_DETAILS table function - Get unit of work metrics as an XML document REQUEST METRICS BASE
MON_GET_WORKLOAD table function - Get workload metrics REQUEST METRICS BASE
MON_GET_WORKLOAD_DETAILS table function - Get workload metrics as an XML document REQUEST METRICS BASE
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities ACTIVITY METRICS BASE
Table 69. Event monitoring information
Event type Logical data grouping Monitor switch
Activities event_activitymetrics ACTIVITY METRICS BASE
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_superclassmetrics REQUEST METRICS BASE
Statistics event_wlmetrics REQUEST METRICS BASE
Package cache pkgcache_metrics ACTIVITY METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE