Feature
This view displays the session information about all OBServer nodes of a tenant.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer. |
| SQL_PORT | bigint(20) | NO | The SQL port number. |
| ID | bigint(20) unsigned | NO | The session ID. |
| USER | varchar(32) | NO | The username. |
| HOST | varchar(128) | NO | The hostname of the client. For example, if you connect to the OBServer through an OBProxy, the value is the host address of the OBProxy. |
| DB | varchar(128) | YES | The name of the database accessed. |
| TENANT | varchar(128) | NO | The name of the tenant accessed. |
| COMMAND | varchar(4096) | NO | The type of the command being executed in the session. |
| TIME | bigint(20) | NO | The execution time of the current command, in seconds. If a retry occurs, the value is cleared and recalculated. |
| TOTAL_TIME | bigint(20) | NO | The total execution time of the current command, in seconds. If a retry occurs, the value will not be cleared. |
| STATE | varchar(128) | YES | The current session status. |
| INFO | varchar(262143) | YES | The command that is being executed. |
| PROXY_SESSID | bigint(20) unsigned | YES | The OBProxy session ID is displayed if the client is an OBProxy. |
| MASTER_SESSID | bigint(20) unsigned | YES | The ID of the master session, which is used to concatenate multiple sub-sessions of the same SQL statement. |
| USER_CLIENT_IP | varchar(46) | YES | The IP address of the user client. |
| USER_HOST | varchar(128) | YES | The hostname of the user client. |
| RETRY_CNT | bigint(20) | NO | The number of retries of the current command. |
| RETRY_INFO | bigint(20) | NO | The retry information about the current command. Generally, the value is the error code of the last retry. |
| SQL_ID | varchar(32) | NO | The ID of the SQL statement. |
| TRANS_ID | bigint(20) unsigned | NO | The ID of the transaction. |
| THREAD_ID | bigint(20) unsigned | NO | The thread ID. |
| SSL_CIPHER | varchar(4096) | YES | The encryption password. |
| TRACE_ID | varchar(64) | YES | The trace ID. |
| TRANS_STATE | varchar(32) | YES | The transaction status. |
| ACTION | varchar(4096) | YES | The name of the operation being executed that is set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | varchar(4096) | YES | The name of the module that is set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure. |
| CLIENT_INFO | varchar(4096) | YES | The client information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure. |