Note
This view is introduced since OceanBase Database V4.3.0.
Purpose
The V$OB_SESSION view displays information about sessions created on the current OBServer node.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| ID | NUMBER(38) | NO | The ID of the session. |
| USER | CHAR(193) | NO | The user to which the session belongs. |
| TENANT | VARCHAR2(128) | NO | The name of the tenant accessed. |
| HOST | VARCHAR2(128) | NO | The IP address and port number of the client that initiated the session. If OceanBase Database Proxy (ODP) was used to connect to the database, the value indicates the host IP address and port number of ODP. |
| DB | VARCHAR2(128) | YES | The name of the database to which the session connects. |
| COMMAND | VARCHAR2(4096) | NO | The type of the statement being executed in the session. |
| SQL_ID | VARCHAR2(32) | NO | The ID of the SQL statement. |
| TIME | NUMBER(38) | NO | The execution time of the current statement, in seconds. If a retry occurs, the value is cleared and recalculated. |
| STATE | VARCHAR2(128) | YES | The current status of the session. |
| INFO | VARCHAR2(262143) | YES | The statement being executed in the session. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The remote procedure call (RPC) port number of the OBServer node. |
| SQL_PORT | NUMBER(38) | NO | The SQL port number of the OBServer node. |
| PROXY_SESSID | NUMBER(38) | YES | The session ID of ODP, if ODP is used for connection. |
| USER_CLIENT_IP | VARCHAR2(46) | YES | The IP address of the user client. |
| USER_HOST | VARCHAR2(128) | YES | The hostname of the user client. |
| TRANS_ID | NUMBER(38) | NO | The transaction ID. |
| THREAD_ID | NUMBER(38) | NO | The thread ID. |
| TRACE_ID | VARCHAR2(64) | YES | The trace ID. |
| REF_COUNT | NUMBER(38) | NO | The reference count of the connection. |
| BACKTRACE | VARCHAR2(16384) | YES | The call stack for connection references. |
| TRANS_STATE | VARCHAR2(32) | YES | The transaction status. |
| TOTAL_CPU_TIME | NUMBER(38) | NO | The CPU time spent on executing the current statement, in seconds. |
Sample query
obclient [SYS]> SELECT * FROM SYS.V$OB_SESSION WHERE ROWNUM <= 2;