Note
This view was introduced in OceanBase Database V4.0.0.
Purpose
The V$OB_PROCESSLIST view displays the information about sessions on the current OBServer node.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| SQL_PORT | bigint(20) | NO | The SQL port number. |
| ID | bigint(20) unsigned | NO | The ID of the session. |
| USER | varchar(32) | NO | The username. |
| HOST | varchar(128) | NO | The name of the client host. For example, if you connect to the OBServer node by using OceanBase Database Proxy (ODP), the value is the host address of ODP. |
| DB | varchar(128) | NO | 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) | NO | The current session status. |
| INFO | varchar(262143) | NO | The command that is being executed. |
| PROXY_SESSID | bigint(20) unsigned | NO | The ODP session ID is displayed if the client is ODP. |
| MASTER_SESSID | bigint(20) unsigned | NO | The ID of the master session, which is used to concatenate multiple sub-sessions of the same SQL statement. |
| USER_CLIENT_IP | varchar(46) | NO | The IP address of the user client. |
| USER_HOST | varchar(128) | NO | 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 of the current command, which is usually the error code for 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 ID of the thread. |
| SSL_CIPHER | varchar(4096) | NO | The name of the SSL cipher. |
| TRACE_ID | varchar(64) | NO | The trace ID. |
| TRANS_STATE | varchar(32) | NO | The status of the transaction. Valid values:
|
| ACTION | varchar(4096) | NO | The name of the operation being executed that is set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | varchar(4096) | NO | The name of the module that is set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure. |
| CLIENT_INFO | varchar(4096) | NO | The client information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure. |
| LEVEL | bigint(20) | NO | The diagnostic information monitoring level for end-to-end diagnostics of the session. For example, the value 1 indicates that level-1 diagnostic information is monitored.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| SAMPLE_PERCENTAGE | bigint(20) | NO | The sampling rate for end-to-end diagnostics of the session. For example, the value 50 indicates that diagnostic information is sampled at a rate of 50%.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| RECORD_POLICY | varchar(32) | NO | The diagnostic information recording strategy for end-to-end diagnostics of the session. Three strategies are supported:
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| LB_VID | bigint(20) | NO | The virtual private cloud (VPC) ID of the load balancing service if you directly connect to the database in the public cloud. Otherwise, the value is NULL.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| LB_VIP | varchar(46) | NO | The IP address used by the client to connect to the load balancing service if you directly connect to the database in the public cloud. Otherwise, the value is NULL.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| LB_VPORT | bigint(20) | NO | The port used by the client to connect to the load balancing service if you directly connect to the database in the public cloud. Otherwise, the value is NULL.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| IN_BYTES | bigint(20) | NO | The inbound traffic of the session, in bytes.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| OUT_BYTES | bigint(20) | NO | The outbound traffic of the session, in bytes.
NoteThis column is available in OceanBase Database V4.2.1 and later. |
| USER_CLIENT_PORT | bigint(20) | NO | The port number of the client that initiates the session.
Note
|
| TOTAL_CPU_TIME | bigint(21) | NO | The CPU time consumed by the current command, in seconds.
Note
|
| PROXY_USER | varchar(128) | NO |
Note
|
Sample query
Query the information about sessions on the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_PROCESSLIST LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221487631
USER: root
HOST: xx.xx.xx.xx:63882
DB: oceanbase
TENANT: mysql001
COMMAND: Query
TIME: 0.000255
TOTAL_TIME: 0.000313
STATE: ACTIVE
INFO: SELECT * FROM oceanbase.V$OB_PROCESSLIST LIMIT 1
PROXY_SESSID: NULL
MASTER_SESSID: NULL
USER_CLIENT_IP: xx.xx.xx.xx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: AFC78717E0B976D0DC70A25E11A4DD96
TRANS_ID: 0
THREAD_ID: 87893
SSL_CIPHER: NULL
TRACE_ID: YB42AC1E87EB-000XXXXXXXXXXXX-0-0
TRANS_STATE:
ACTION:
MODULE:
CLIENT_INFO:
LEVEL: 1
SAMPLE_PERCENTAGE: 10
RECORD_POLICY: SAMPLE_AND_SLOW_QUERY
LB_VID: NULL
LB_VIP: NULL
LB_VPORT: NULL
IN_BYTES: 458
OUT_BYTES: 0
USER_CLIENT_PORT: 63882
TOTAL_CPU_TIME: 0
PROXY_USER:
1 row in set