Note
This view is available starting with V4.0.0.
Purpose
The GV$OB_PROCESSLIST view displays session information for all OBServer nodes of the current tenant.
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 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 currently being executed. |
| TIME | NUMBER(38) | NO | The time when the current command is executed, in seconds. If the command is retried, this value is reset to 0. |
| TOTAL_TIME | NUMBER(38) | NO | The total execution time of the current command, in seconds. If the command is retried, this value is not reset. |
| STATE | VARCHAR2(128) | YES | The current session state. |
| INFO | VARCHAR2(262143) | YES | The command currently 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 ID of the master session. This ID 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 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 for the current command. This field generally 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 (empty if no transaction is active on the session):
|
| 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 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) | 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, it 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 client that connects to the load balancer. Otherwise, it 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 client that connects to the load balancer. Otherwise, it 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.
Note
|
| PROXY_USER | VARCHAR2(128) | YES |
Note
|
| SERVICE_NAME | VARCHAR2(64) | YES | The service name that created the session. A value of NULL indicates that 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
|
| MEMORY_USAGE | NUMBER(38) | YES | The memory size occupied by a single SQL statement, in bytes.
NoteFor V4.4.x, this column was introduced in V4.4.0, but it is not effective yet. The default value of this column is |
| TOP_TIME | NUMBER(38) | NO | The top_time column in the PL scenario indicates the total execution time of the PL.
NoteFor V4.4.x, this column was introduced in V4.4.1. |
| TOP_TRACE_ID | varchar(64) | YES | The traceid of the top-level statement.
NoteFor V4.4.x, this column was introduced in V4.4.1. |
Sample query
Query the session information of all OBServer nodes where the tenant resides.
obclient [SYS]> SELECT * FROM SYS.GV$OB_PROCESSLIST WHERE ROWNUM < = 1 \G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 6.12.xxx.xxx
SVR_PORT: 2882
SQL_PORT: 2881
ID: 3221607558
USER: SYS
HOST: 100.xx.xxx.xxx:30147
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: 100.xx.xxx.xxx
USER_HOST: %
RETRY_CNT: 0
RETRY_INFO: 0
SQL_ID: 84C807E77686C3D090C55F1D53164D9A
TRANS_ID: 0
THREAD_ID: 3304791
SSL_CIPHER: NULL
TRACE_ID: YB42060CEB9F-000643607B0D509B-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: 30147
PROXY_USER: NULL
SERVICE_NAME: NULL
TOTAL_CPU_TIME: 0
TOP_INFO: NULL
MEMORY_USAGE: 3596288
TOP_TIME: 0
TOP_TRACE_ID: YB42060CEB9F-000643607B0D509B-0-0
1 row in set (0.037 sec)