MON_GET_EXTENDED_LATCH_WAIT table function - Return information for latches
This function returns information for latches which have been involved in extended latch waits. This information includes the member, latch name, number of extended waits, and time spent in extended waits.
Syntax
The schema is SYSPROC.
Table function parameters
- member
- The member ID for which to return data. If NULL or -1 is specified, data for the currently connected member will be returned. If -2 is specified, data from all active members will be returned. Otherwise, only data for the specified member will be returned. If an invalid, undefined, or offline member is specified, no data will be returned.
Authorization
One of the following authorities is required to execute the routine:
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
None
Usage notes
The MON_GET_EXTENDED_LATCH_WAIT returns informations about which latches on a given member have been involved in extended latch waits, including how much time and how many times the particular latch has been involved in extended latch waits. This information will be collected as part of the base monitor metrics.
Information returned
| Column Name | Data Type | Description |
|---|---|---|
| MEMBER | SMALLINT | member- Database member |
| LATCH_NAME | VARCHAR(256) | latch_name - Latch name monitor element |
| TOTAL_EXTENDED_LATCH_WAITS | BIGINT | total_extended_latch_waits - Total extended latch waits |
| TOTAL_EXTENDED_LATCH_WAIT_TIME | BIGINT | total_extended_latch_wait_time - Total extended latch wait time |