Note
This view is available starting with V4.0.0.
Purpose
The V$OB_PROCESSLIST view displays session information on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| SQL_PORT | NUMBER(38) | NO | The port number of the SQL service. |
| ID | NUMBER(38) | NO | The session ID.
|
| USER | CHAR(193) | NO | The username. |
| HOST | VARCHAR2(128) | NO | The IP address and port number of the client. |
| DB | VARCHAR2(128) | YES | The name of the database being accessed. |
| TENANT | VARCHAR2(128) | NO | The name of the tenant being accessed. |
| COMMAND | VARCHAR2(4096) | NO | The type of the command being executed. |
| TIME | NUMBER(38) | NO | The execution time of the current command, in seconds. If the command is retried, the value is reset to 0 and recalculated. |
| TOTAL_TIME | NUMBER(38) | NO | The total execution time of the current command, in seconds. If the command is retried, the value is not reset. |
| STATE | VARCHAR2(128) | YES | The current session state. |
| INFO | VARCHAR2(262143) | YES | The command being executed. |
| PROXY_SESSID | NUMBER(38) | YES | If the client is an ODP, this column displays the proxy session ID. |
| MASTER_SESSID | NUMBER(38) | YES | The master session ID, which is used to link multiple sub-sessions of the same SQL statement. |
| USER_CLIENT_IP | VARCHAR2(46) | YES | The IP address of the client. |
| USER_HOST | VARCHAR2(128) | YES | The host name of the client. |
| RETRY_CNT | NUMBER(38) | NO | The number of retries for the current command. |
| RETRY_INFO | NUMBER(38) | NO | The retry information of the current command, which is generally the error code of the last retry. |
| SQL_ID | VARCHAR2(32) | NO | The SQL ID. |
| TRANS_ID | NUMBER(38) | NO | The transaction ID. |
| THREAD_ID | NUMBER(38) | NO | The thread ID. |
| SSL_CIPHER | VARCHAR2(4096) | YES | The name of the encryption cipher. |
| TRACE_ID | VARCHAR2(64) | YES | The trace ID. |
| TRANS_STATE | VARCHAR2(32) | YES | The transaction state. If no transaction is associated with the session, this column is empty.
|
| ACTION | VARCHAR2(4096) | YES | The name of the current operation, which is set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | VARCHAR2(4096) | YES | The name of the current operation, which is set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure. |
| CLIENT_INFO | VARCHAR2(4096) | YES | The information set by calling the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure. |
| LEVEL | NUMBER(38) | 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 | NUMBER(38) | NO | The end-to-end tracing sampling frequency of the session. For example, 50 indicates that diagnostic information is sampled at a frequency of 50%.
NoteThis column is available starting with V4.2.1. |
| RECORD_POLICY | VARCHAR2(32) | NO | The end-to-end tracing record strategy of the session. The following three strategies are supported:
NoteThis column is available starting with V4.2.1. |
| LB_VID | NUMBER(38) | NO | If the database is directly connected to the load balancer in the public cloud, this column displays the VPC ID of the load balancer. Otherwise, this column is empty.
NoteThis column is available starting with V4.2.1. |
| LB_VIP | VARCHAR2(46) | NO | If the database is directly connected to the load balancer in the public cloud, this column displays the IP address of the load balancer. Otherwise, this column is empty.
NoteThis column is available starting with V4.2.1. |
| LB_VPORT | NUMBER(38) | NO | If the database is directly connected to the load balancer in the public cloud, this column displays the port of the load balancer. Otherwise, this column is empty.
NoteThis column is available starting with V4.2.1. |
| IN_BYTES | NUMBER(38) | NO | The inflow traffic of the session, in bytes.
NoteThis column is available starting with V4.2.1. |
| OUT_BYTES | NUMBER(38) | NO | The outflow traffic of the session, in bytes.
NoteThis column is available starting with V4.2.1. |
| USER_CLIENT_PORT | NUMBER(38) | NO | The client address information.
Note
|
| PROXY_USER | VARCHAR2(128) | YES |
Note
|
| SERVICE_NAME | VARCHAR2(64) | YES | The service name of the session that created the session. If the value is NULL, the session was not created by a service name.
Note
|
| TOTAL_CPU_TIME | NUMBER(38) | NO | The CPU time consumed by the current command, in seconds.
Note
|
| TOP_INFO | VARCHAR2(262143) | YES | The top-level PL statement information of the executing SQL.
Note
|
| TOP_TIME | NUMBER(38) | NO | The top_time column indicates the total execution time of the PL statement.
NoteFor V4.4.x, this column was introduced in V4.4.1. |
| TOP_TRACE_ID | varchar(64) | NO | The traceid of the top-level statement.
NoteFor V4.4.x, this column was introduced in V4.4.1. |
| MEMORY_USAGE | NUMBER(38) | NO | The size of memory occupied by the current SQL statement, in bytes.
NoteFor V4.4.x, this column was introduced in V4.4.0, but it is not effective yet. The column value is |
Sample query
Query the session information of the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_PROCESSLIST WHERE ROWNUM < = 1 \G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 6.xx.xxx.xxx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221659896
USER: SYS
HOST: 100.xx.xxx.xxx:39184
DB: SYS
TENANT: oracle001
COMMAND: Query
TIME: 0
TOTAL_TIME: 0
STATE: ACTIVE
INFO: SELECT * FROM SYS.V$OB_PROCESSLIST WHERE ROWNUM < = 1
PROXY_SESSID: NULL
MASTER_SESSID: NULL
USER_CLIENT_IP: 100.xx.xxx.xxx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: EF50802B8426B999EDC33F5F27D0A204
TRANS_ID: 0
THREAD_ID: 3304791
SSL_CIPHER: NULL
TRACE_ID: YB42060CEB9F-000643607B0D5092-0-0
TRANS_STATE: NULL
ACTION: NULL
MODULE: NULL
CLIENT_INFO: NULL
LEVEL: 1
SAMPLE_PERCENTAGE: 10
RECORD_POLICY: SAMPLE_AND_SLOW_QUERY
LB_VID: NULL
LB_VIP: NULL
LB_VPORT: NULL
IN_BYTES: 448
OUT_BYTES: 0
USER_CLIENT_PORT: 39184
PROXY_USER: NULL
SERVICE_NAME: NULL
TOTAL_CPU_TIME: 0
TOP_INFO: NULL
MEMORY_USAGE: 253952
TOP_TIME: 0
TOP_TRACE_ID: YB42060CEB9F-000643607B0D5092-0-0
1 row in set (0.047 sec)