Note
This view is available starting with V4.0.0.
Purpose
The V$OB_PROCESSLIST view displays session information for the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| SQL_PORT | bigint(20) | NO | The port number of the SQL service. |
| ID | bigint(20) unsigned | NO | The session ID.
|
| USER | varchar(32) | NO | The username. |
| HOST | varchar(128) | NO | The IP address and port number of the client. |
| DB | varchar(128) | NO | The name of the database being accessed. |
| TENANT | varchar(128) | NO | The name of the tenant being accessed. |
| COMMAND | varchar(4096) | NO | The type of the command being executed. |
| TIME | bigint(20) | NO | The time when the command is executed, in seconds. If the command is retried, this value is reset to 0. |
| TOTAL_TIME | bigint(20) | NO | The total execution time of the command, in seconds. If the command is retried, this value is not reset. |
| STATE | varchar(128) | NO | The session state. |
| INFO | varchar(262143) | NO | The command being executed. |
| PROXY_SESSID | bigint(20) unsigned | NO | If the client is an OBProxy, this column displays the proxy session ID. |
| MASTER_SESSID | bigint(20) unsigned | NO | The session ID of the master session. This session ID is used to link multiple sub-sessions of the same SQL statement. |
| USER_CLIENT_IP | varchar(46) | NO | The IP address of the client. |
| USER_HOST | varchar(128) | NO | The host name of the client. |
| RETRY_CNT | bigint(20) | NO | The number of retries for the current command. |
| RETRY_INFO | bigint(20) | NO | The retry information of the current command, which is generally the error code of the last retry. |
| SQL_ID | varchar(32) | NO | The SQL ID. |
| TRANS_ID | bigint(20) unsigned | NO | The transaction ID. |
| THREAD_ID | bigint(20) unsigned | NO | The thread ID. |
| SSL_CIPHER | varchar(4096) | NO | The name of the encryption cipher. |
| TRACE_ID | varchar(64) | NO | The trace ID. |
| TRANS_STATE | varchar(32) | NO | The transaction state (blank if no transaction exists for the session).
|
| ACTION | varchar(4096) | NO | The name of the current operation, which is set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | varchar(4096) | NO | The name of the current operation, which is set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure. |
| CLIENT_INFO | varchar(4096) | NO | The information set by calling the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure. |
| LEVEL | bigint(20) | NO | The end-to-end tracing monitoring level of the session. For example, 1 indicates the diagnostic information of level 1.
NoteThis column is available starting with V4.2.1. |
| SAMPLE_PERCENTAGE | bigint(20) | NO | The end-to-end tracing sampling frequency of the session. For example, 50 indicates that diagnostic information is sampled at 50% frequency.
NoteThis column is available starting with V4.2.1. |
| RECORD_POLICY | varchar(32) | NO | The end-to-end tracing record policy of the session. The following three policies are supported:
NoteThis column is available starting with V4.2.1. |
| LB_VID | bigint(20) | NO | If the database is directly connected to the load balancer in a public cloud environment, this column displays the VPC ID of the load balancer. Otherwise, it displays NULL.
NoteThis column is available starting with V4.2.1. |
| LB_VIP | varchar(46) | NO | If the database is directly connected to the load balancer in a public cloud environment, this column displays the IP address of the client connecting to the load balancer. Otherwise, it displays NULL.
NoteThis column is available starting with V4.2.1. |
| LB_VPORT | bigint(20) | NO | If the database is directly connected to the load balancer in a public cloud environment, this column displays the port of the client connecting to the load balancer. Otherwise, it displays NULL.
NoteThis column is available starting with V4.2.1. |
| IN_BYTES | bigint(20) | NO | The incoming traffic of the session, in bytes.
NoteThis column is available starting with V4.2.1. |
| OUT_BYTES | bigint(20) | NO | The outgoing traffic of the session, in bytes.
NoteThis column is available starting with V4.2.1. |
| USER_CLIENT_PORT | bigint(20) | NO | The client address information.
Note
|
| PROXY_USER | varchar(128) | NO |
Note
|
| SERVICE_NAME | varchar(64) | YES | The service name that created the session. If the value is NULL, the session was not created by a service name.
Note
|
| TOTAL_CPU_TIME | bigint(21) | NO | The CPU time consumed by the current command, in seconds
Note
|
| TOP_INFO | varchar(262143) | YES | The top-level PL statement information of the executing SQL statement.
Note
|
| MEMORY_USAGE | bigint(20) | NO | The amount of memory occupied by the current SQL statement, in bytes.
NoteFor V4.4.x, this column was introduced in V4.4.0. However, it is not effective yet. The value of this column is |
Sample query
Query the session information on the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_PROCESSLIST LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
*************************** 1. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221735835
USER: root
HOST: 100.xx.xxx.xxx:28135
DB: demo
TENANT: mysql001
COMMAND: Query
TIME: 120.800875
TOTAL_TIME: 0.000136
STATE: ACTIVE
INFO: INSERT INTO orders (
user_id,
product_name,
order_amount,
order_date,
order_status
) VALUES (
FLOOR(RAND() * 10000),
CONCAT('Product ', FLOOR(RAND() * 1000)),
ROUND(RAND() * 1000, 2),
DATE_SUB(NOW(), INTERVAL FLOOR(RAND() * 1500) DAY),
ELT(FLOOR(RAND() * 3 + 1), 'pending', 'completed', 'cancelled')
)
PROXY_SESSID: NULL
MASTER_SESSID: NULL
USER_CLIENT_IP: 100.xx.xxx.xxx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: A2572E6AF77AEF27E893F08559A9FA67
TRANS_ID: 1463901
THREAD_ID: 2443
SSL_CIPHER: NULL
TRACE_ID: YB4***************************************-0-0
TRANS_STATE: IN_TERMINATE
ACTION:
MODULE:
CLIENT_INFO:
LEVEL: 1
SAMPLE_PERCENTAGE: 50
RECORD_POLICY: ALL
LB_VID: NULL
LB_VIP: NULL
LB_VPORT: NULL
IN_BYTES: 447
OUT_BYTES: 0
USER_CLIENT_PORT: 28135
PROXY_USER:
SERVICE_NAME: NULL
TOTAL_CPU_TIME: 121
TOP_INFO: CALL generate_test_orders()
MEMORY_USAGE: NULL
1 row in set