Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The V$OB_PROCESSLIST view displays 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 hostname of the client. For example, if you connect to the OBServer node by using an OceanBase Database Proxy (ODP), the value is the host address of the 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 an 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 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 ID of the thread. |
| SSL_CIPHER | varchar(4096) | NO | The encryption password. |
| 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 introduced since OceanBase Database V4.2.1. |
| 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 introduced since OceanBase Database V4.2.1. |
| 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 introduced since OceanBase Database V4.2.1. |
| LB_VID | bigint(20) | NO | The VPC ID of the load balancing service if you directly connect to the database in a public cloud by using the load balancing service. Otherwise, the value is NULL.
NoteThis column is introduced since OceanBase Database V4.2.1. |
| 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 a public cloud by using the load balancing service. Otherwise, the value is NULL.
NoteThis column is introduced since OceanBase Database V4.2.1. |
| 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 a public cloud by using the load balancing service. Otherwise, the value is NULL.
NoteThis column is introduced since OceanBase Database V4.2.1. |
| IN_BYTES | bigint(20) | NO | The inbound traffic of the session, in bytes.
NoteThis column is introduced since OceanBase Database V4.2.1. |
| OUT_BYTES | bigint(20) | NO | The outbound traffic of the session, in bytes.
NoteThis column is introduced since OceanBase Database V4.2.1. |
| TOTAL_CPU_TIME | bigint(21) | NO | The CPU time spent on executing the current statement, in seconds.
NoteThis column is introduced since OceanBase Database V4.3.1. |
Sample query
Query information about sessions on the current OBServer node.
obclient> 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: 3221487789
USER: root
HOST: xx.xx.xx.xx:59697
DB: oceanbase
TENANT: sys
COMMAND: Query
TIME: 0.005439
TOTAL_TIME: 0.005512
STATE: ACTIVE
INFO: select * from 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: 1E2AE144FE8CB891AA8138FC74EDCAB2
TRANS_ID: 0
THREAD_ID: 19932
SSL_CIPHER: NULL
TRACE_ID: YBXXXXXXXX-000XXXXXXXXXXX-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: 845
OUT_BYTES: 15567
TOTAL_CPU_TIME: 0
1 row in set (0.006 sec)