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 | 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 for SQL. |
| 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 to be accessed. |
| TENANT | VARCHAR2(128) | NO | The name of the tenant to be 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 status. |
| INFO | VARCHAR2(262143) | YES | The command being executed. |
| PROXY_SESSID | NUMBER(38) | YES | If the client is an ODP, this field indicates the proxy session ID. |
| MASTER_SESSID | NUMBER(38) | YES | The session ID of the main session. This field 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. This field usually indicates 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, set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure. |
| MODULE | VARCHAR2(4096) | YES | The name of the current operation, 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 50% frequency.
NoteThis column is available starting with V4.2.1. |
| RECORD_POLICY | VARCHAR2(32) | NO | The end-to-end tracing recording policy of the session. The following three policies 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 a public cloud environment, 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 a public cloud environment, this column displays the IP address of the client connecting to 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 a public cloud environment, this column displays the port of the client connecting to 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 name of the service that created the session. If the value is NULL, the session was not created by a service.
Note
|
| TOTAL_CPU_TIME | NUMBER(38) | NO | The CPU time used to execute the current command, in seconds.
Note
|
| TOP_INFO | VARCHAR2(262143) | YES | The information of the top-level PL statement that contains the currently executing SQL statement.
Note
|
| MEMORY_USAGE | NUMBER(38) | NO | The size of memory occupied by the current SQL statement, in bytes.
NoteFor V4.4.x, this column is available starting with V4.4.0, but it is not effective at present. The default value of this column is |
Sample query
Query session information on 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: 172.xx.xxx.xxx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221659094
USER: SYS
HOST: 100.xx.xxx.xxx:12716
DB: SYS
TENANT: oracle001
COMMAND: Query
TIME: 0
TOTAL_TIME: 0
STATE: ACTIVE
INFO: SELECT * FROM SYS.GV$OB_PROCESSLIST
PROXY_SESSID: NULL
MASTER_SESSID: NULL
USER_CLIENT_IP: 100.xx.xxx.xxx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: 0A6CF0E2AB2C1A1917AB1FFDF2BE9CFF
TRANS_ID: 23035
THREAD_ID: 2743
SSL_CIPHER: NULL
TRACE_ID: YB4**************************-0-0
TRANS_STATE: ACTIVE
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: 12716
PROXY_USER: NULL
SERVICE_NAME: NULL
TOTAL_CPU_TIME: 0
TOP_INFO: NULL
MEMORY_USAGE: NULL
1 row in set