Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The V$OB_PROCESSLIST view displays session information on this 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 of the server. |
| SQL_PORT | bigint(20) | NO | The port for SQL statements. |
| ID | bigint(20) unsigned | NO | The session ID. |
| USER | varchar(32) | NO | The username. |
| HOST | varchar(128) | NO | The host name of the client. (For connections through obproxy, this column displays the host address of obproxy.) |
| 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 current command. |
| TIME | bigint(20) | NO | The execution time of the current command in seconds. If the command is retried, the value is reset to 0. |
| TOTAL_TIME | bigint(20) | NO | The total execution time of the current command in seconds. If the command is retried, the value is not reset. |
| STATE | varchar(128) | NO | The current session status. |
| INFO | varchar(262143) | NO | The current command being executed. |
| PROXY_SESSID | bigint(20) unsigned | NO | The proxy session ID if the client is obproxy. |
| MASTER_SESSID | bigint(20) unsigned | NO | The master session ID, which is used to chain multiple subsessions of the same SQL statement. |
| USER_CLIENT_IP | varchar(46) | NO | The IP address of the user client. |
| USER_HOST | varchar(128) | NO | The host name 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 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.
|
| ACTION | varchar(4096) | NO | The name of the current operation set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | varchar(4096) | NO | The name of the current operation 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 full-link trace monitoring level of the session. For example, 1 indicates level 1 diagnostic information.
NoteThis field was introduced in V4.2.1. |
| SAMPLE_PERCENTAGE | bigint(20) | NO | The full-link trace sampling frequency of the session. For example, 50 indicates that diagnostic information is sampled at a 50% frequency.
NoteThis field was introduced in V4.2.1. |
| RECORD_POLICY | varchar(32) | NO | The full-link trace recording strategy of the session. It supports the following three strategies:
NoteThis field was introduced in V4.2.1. |
| LB_VID | bigint(20) | NO | If you directly connect to the database through load balancing in a public cloud environment, this column displays the VPC ID of the load balancing service. Otherwise, it displays NULL.
NoteThis field was introduced in V4.2.1. |
| LB_VIP | varchar(46) | NO | If you directly connect to the database through load balancing in a public cloud environment, this column displays the IP address of the client connecting to the load balancing service. Otherwise, it displays NULL.
NoteThis field was introduced in V4.2.1. |
| LB_VPORT | bigint(20) | NO | If you directly connect to the database through load balancing in a public cloud environment, this column displays the port of the client connecting to the load balancing service. Otherwise, it displays NULL.
NoteThis field was introduced in V4.2.1. |
| IN_BYTES | bigint(20) | NO | The incoming traffic of the session in bytes.
NoteThis field was introduced in V4.2.1. |
| OUT_BYTES | bigint(20) | NO | The outgoing traffic of the session in bytes.
NoteThis field was introduced in 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 name of the service that created the session. The value is NULL if the session was not created by a service name.
Note
|
| TOTAL_CPU_TIME | bigint(21) | NO | The CPU usage time of the current command in seconds.
Note
|
| TOP_INFO | varchar(262143) | YES | The information of the top-level PL statement where the executing SQL statement is located.
Note
|
| MEMORY_USAGE | bigint(20) | NO | The memory occupied by a single SQL statement, in bytes.
NoteFor V4.3.5, this field was introduced in V4.3.5 BP2. |
| TOP_TIME | double | NO | The top_time column in the PL scenario indicates the entire PL execution time.
NoteIn V4.3.x, this field was introduced in V4.3.5 BP5. |
| TOP_TRACE_ID | varchar(64) | YES | The traceid of the top-level statement.
NoteIn V4.3.x, this field was introduced in V4.3.5 BP5. |
Sample queries
Query the session information of this 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