Note
This view is available starting with V4.0.0.
Purpose
The GV$OB_PROCESSLIST view displays session information for all OBServer nodes where the tenant resides.
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 SQL. |
| ID | NUMBER(38) | NO | The session ID. |
| USER | CHAR(193) | NO | The username. |
| HOST | VARCHAR2(128) | NO | The name of the client host. (For example, if the client connects through an OBProxy, this field displays the IP address of the OBProxy.) |
| DB | VARCHAR2(128) | YES | The name of the database. |
| TENANT | VARCHAR2(128) | NO | The name of the tenant. |
| COMMAND | VARCHAR2(4096) | NO | The type of the command being executed. |
| TIME | NUMBER(38) | NO | The time taken for the current command to execute, in seconds. If the command is retried, this value is reset to 0 and recalculated. |
| TOTAL_TIME | NUMBER(38) | NO | The total time taken for the command to execute, in seconds.
NoteBefore V4.2.5, this field displayed the total time taken for the command to execute, and this value was not reset during retries. |
| 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 OBProxy, this field displays the proxy session ID. |
| MASTER_SESSID | NUMBER(38) | YES | The ID of the master session, 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 name of the client host. |
| RETRY_CNT | NUMBER(38) | NO | The number of retries for the current command. |
| RETRY_INFO | NUMBER(38) | NO | The retry information for the current command, typically 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. Valid values:
|
| 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 trace 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 trace sampling rate of the session. For example, 50 indicates that the diagnostic information is sampled with a 50% probability.
NoteThis column is available starting with V4.2.1. |
| RECORD_POLICY | VARCHAR2(32) | NO | The end-to-end trace recording policy of the session. The following three policies are supported:
NoteThis column is available starting with V4.2.1. |
| LB_VID | NUMBER(38) | YES | 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 displays NULL.
NoteThis column is available starting with V4.2.1. |
| LB_VIP | VARCHAR2(46) | YES | If the database is directly connected to the load balancer in a public cloud environment, this column displays the IP address of the load balancer. Otherwise, this column displays NULL.
NoteThis column is available starting with V4.2.1. |
| LB_VPORT | NUMBER(38) | YES | If the database is directly connected to the load balancer in a public cloud environment, this column displays the port of the load balancer. Otherwise, this column displays NULL.
NoteThis column is available starting with V4.2.1. |
| IN_BYTES | NUMBER(38) | NO | The incoming traffic of the session, in bytes.
NoteThis column is available starting with V4.2.1. |
| OUT_BYTES | NUMBER(38) | NO | The outgoing 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.
NoteThis column is available starting with V4.2.3. |
| PROXY_USER | VARCHAR2(128) | YES |
NoteThis column is available starting with V4.2.3. |
| TOTAL_CPU_TIME | VARCHAR2(38) | NO | The CPU time consumed by the current command, in seconds.
Note
|
| SERVICE_NAME | VARCHAR2(64) | YES | The service name that created the session. If the value is NULL, the session was not created by a service name.
NoteThis column is available starting with V4.2.4. |
| TOP_INFO | VARCHAR2(262143) | YES | The information of the top PL statement where the SQL statement is executed.
Note
|
| MEMORY_USAGE | NUMBER(38) | YES | The size of memory used by the SQL statement, in bytes.
NoteThis column is available starting with V4.2.5 BP2. |
Sample query
Query the session information of all OBServer nodes where the tenant is located.
obclient [SYS]> SELECT * FROM SYS.GV$OB_PROCESSLIST WHERE ROWNUM <= 1\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221671593
USER: SYS
HOST: xx.xx.xx.xx:51303
DB: SYS
TENANT: oracle001
COMMAND: Query
TIME: 0
TOTAL_TIME: 0
STATE: ACTIVE
INFO: SELECT * FROM SYS.GV$OB_PROCESSLIST WHERE ROWNUM <= 1
PROXY_SESSID: NULL
MASTER_SESSID: NULL
USER_CLIENT_IP: xx.xx.xx.xx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: EF2AE7D1CCA62D1F29E1CA0E88E2E5D9
TRANS_ID: 0
THREAD_ID: 126429
SSL_CIPHER: NULL
TRACE_ID: YB42AC1E87E1-000XXXXXXXX-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: 449
OUT_BYTES: 0
USER_CLIENT_PORT: 51303
PROXY_USER: NULL
TOTAL_CPU_TIME: 0
SERVICE_NAME: NULL
TOP_INFO: NULL
MEMORY_USAGE: 3489792
1 row in set