Column Name | Type | Length | Nulls | Description |
|---|---|---|---|---|
server | varchar | 64 | no | DBMS server the session exists in |
session_id | varchar | 32 | no | Session ID of the session |
effective_user | varchar | 32 | no | User ID of the session |
session_group | varchar | 32 | no | Group ID of the session |
session_role | varchar | 32 | no | Role ID of the session |
user_priority | varchar | 1 | no | Wait list priority of the session for the session’s current queue |
wlm_status | varchar | 1 | no | Status: A-Active W-Waiting |
wlm_name | varchar | 60 | no | Queue that the session's current query is using |
wlm_waitnum | integer | 4 | no | The current wait number of the session. If this number is greater than 0, then the query (session) is in a wait list. If this number is 1, then the query is the next one to run. If this number is X, then there are X-1 queries ahead of the query. |
waittime | varchar | 8 | no | Time the session has been waiting in the wait list for the current query |
runtime | varchar | 8 | no | Time the session has been running the current query |
wlm_id | integer | 4 | no | An internally set ID number for the session |
wlm_cpu | varchar | 16 | no | The estimated CPU usage for the session’s query |
wlm_dio | varchar | 16 | no | The estimated disk I/O usage for the session’s query |
session_query | varchar | 4096 | no | The current query run by the session |