Note
- In V4.3.x, this view was introduced in V4.3.5.
- In V4.2.x, this view was introduced in V4.2.2.
Purpose
The V$OB_ACTIVE_SESSION_HISTORY view displays the active session history of the current OBServer node in the tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP address of the server where the sample is located. |
| SVR_PORT | bigint(20) | NO | Port number of the server where the sample is located. |
| SAMPLE_ID | bigint(20) | NO | Unique ID of the sample on the local server. |
| SAMPLE_TIME | datetime | NO | Sampling time. |
| CON_ID | bigint(20) | NO | Tenant ID. |
| USER_ID | bigint(20) | NO | User ID of the sampled session. |
| SESSION_ID | bigint(20) | NO | ID of the sampled session. For V4.3.x:
|
| SESSION_TYPE | varchar(10) | NO | Session type. Valid values include:
|
| SESSION_STATE | varchar(7) | NO | Session status. Valid values include:
|
| SQL_ID | varchar(32) | NO | SQL ID. |
| PLAN_ID | bigint(20) | NO | ID of the sampled SQL statement in the plan cache, which is used to associate the sampling point with the plan. |
| TRACE_ID | varchar(64) | NO | Trace ID of the operator. |
| EVENT | varchar(64) | NO | Description of the waiting event. |
| EVENT_NO | bigint(20) | NO | Internal ID of the waiting event, which is used for queries across tables. |
| EVENT_ID | bigint(20) | NO | ID of the current waiting event. |
| P1TEXT | varchar(64) | NO | Name of parameter 1 of the waiting event. The name varies depending on the event. |
| P1 | bigint(20) | NO | Value of parameter 1 of the waiting event. |
| P2TEXT | varchar(64) | NO | Name of parameter 2 of the waiting event. The name varies depending on the event. |
| P2 | bigint(20) | NO | Value of parameter 2 of the waiting event. |
| P3TEXT | varchar(64) | NO | Name of parameter 3 of the waiting event. The name varies depending on the event. |
| P3 | bigint(20) | NO | Value of parameter 3 of the waiting event. |
| WAIT_CLASS | varchar(64) | NO | Type of the waiting event. |
| WAIT_CLASS_ID | bigint(20) | NO | ID of the type of the waiting event, which is used for queries across tables. |
| TIME_WAITED | bigint(20) | NO | Total waiting time of the waiting event in microseconds (us). |
| SQL_PLAN_LINE_ID | bigint(20) | NO | Number of the SQL operator in the SQL plan when the session was sampled. |
| GROUP_ID | bigint(20) | NO | ID of the resource group to which the session belongs. |
| PLAN_HASH | bigint(20) unsigned | NO | Plan hash value of the current SQL statement. |
| THREAD_ID | bigint(20) | NO | ID of the thread where the current active session resides. |
| STMT_TYPE | bigint(20) | NO | SQL type of the current active session. |
| TIME_MODEL | bigint(20) | NO | time model information, which is a set of IN_XXX fields (such as IN_PARSE and IN_PL_PARSE). |
| IN_PARSE | varchar(1) | NO | Indicates whether the session is parsing an SQL statement during sampling. |
| IN_PL_PARSE | varchar(1) | NO | Indicates whether the session is parsing a PL/SQL statement during sampling. |
| IN_PLAN_CACHE | varchar(1) | NO | Indicates whether the session is matching a plan in the plan cache during sampling. |
| IN_SQL_OPTIMIZE | varchar(1) | NO | Indicates whether the session is optimizing an SQL statement during sampling. |
| IN_SQL_EXECUTION | varchar(1) | NO | Indicates whether the session is executing an SQL statement during sampling. |
| IN_PX_EXECUTION | varchar(1) | NO | Indicates whether the session is executing a parallel SQL statement during sampling. When the session is in this state, it must also be in the IN_SQL_EXECUTION state. |
| IN_SEQUENCE_LOAD | varchar(1) | NO | Indicates whether the session is fetching values from an auto-increment column or a sequence during sampling. |
| IN_COMMITTING | varchar(1) | NO | Indicates whether the sampling point is in the transaction commit phase. |
| IN_STORAGE_READ | varchar(1) | NO | Indicates whether the sampling point is in the storage read phase. |
| IN_STORAGE_WRITE | varchar(1) | NO | Indicates whether the sampling point is in the storage write phase. |
| IN_REMOTE_DAS_EXECUTION | varchar(1) | NO | Indicates whether the sampling point is in the remote DAS execution phase. |
| IN_FILTER_ROWS | varchar(1) | NO | Indicates whether the sampling point is in the storage downpress execution phase. |
| IN_RPC_ENCODE | varchar(1) | NO | The serialization operation being performed by the current SQL. |
| IN_RPC_DECODE | varchar(1) | NO | The deserialization operation being performed by the current SQL. |
| IN_CONNECTION_MGR | varchar(1) | NO | The connection establishment operation being performed by the current SQL. |
| PROGRAM | varchar(64) | NO | Name of the program being executed at the sampling point:
|
| MODULE | varchar(64) | NO | MODULE value recorded for the session during sampling, which is set by the DBMS_APPLICATION_INFO.SET_MODULE package. |
| ACTION | varchar(64) | NO | ACTION value recorded for the session during sampling, which is set by the DBMS_APPLICATION_INFO.SET_ACTION package. |
| CLIENT_ID | varchar(64) | NO | CLIENT_ID value recorded for the session during sampling, which is set by the DBMS_SESSION.set_identifier package. |
| BACKTRACE | varchar(512) | NO | Auxiliary debugging field that records the code call stack at the time of the event. The value of this field is always NULL. |
| TM_DELTA_TIME | bigint(20) | NO | Time interval for calculating the time model, in microseconds. |
| TM_DELTA_CPU_TIME | bigint(20) | NO | CPU time consumed in the past TM_DELTA_TIME time period. |
| TM_DELTA_DB_TIME | bigint(20) | NO | Database call time consumed in the past TM_DELTA_TIME time period. |
| TOP_LEVEL_SQL_ID | varchar(32) | NO | ID of the top-level SQL statement. |
| IN_PLSQL_COMPILATION | varchar(1) | NO | Current PL compilation status: Y/N |
| IN_PLSQL_EXECUTION | varchar(1) | NO | Current PL execution status: Y/N |
| PLSQL_ENTRY_OBJECT_ID | bigint(20) | NO | OBJECT ID of the top-level PL. |
| PLSQL_ENTRY_SUBPROGRAM_ID | bigint(20) | NO | Subprogram ID of the top-level PL. |
| PLSQL_ENTRY_SUBPROGRAM_NAME | varchar(32) | NO | Subprogram name of the top-level PL. |
| PLSQL_OBJECT_ID | bigint(20) | NO | ID of the PL currently being executed. |
| PLSQL_SUBPROGRAM_ID | bigint(20) | NO | ID of the subprogram currently being executed. |
| PLSQL_SUBPROGRAM_NAME | varchar(32) | NO | Name of the subprogram currently being executed. |
| TX_ID | bigint(20) | NO | ID of the current transaction. |
| BLOCKING_SESSION_ID | bigint(20) | NO | If the session is blocked, the ID of the session that blocks it. Currently, this field is effective only in lock conflict scenarios and displays the ID of the session that holds the lock. |
| TABLET_ID | bigint(20) | NO | ID of the tablet being processed by the current SQL statement. |
| PROXY_SID | bigint(20) | NO | ID of the proxy session. |
| TX_ID | bigint(20) | NO | Current transaction ID. |
| DELTA_READ_IO_REQUESTS | bigint(20) | NO | Number of reads between two samples.
Note
|
| DELTA_READ_IO_BYTES | bigint(20) | NO | Total size of files read between two samples.
Note
|
| DELTA_WRITE_IO_REQUESTS | bigint(20) | NO | Number of writes between two samples.
Note
|
| DELTA_WRITE_IO_BYTES | bigint(20) | NO | Total size of files written between two samples.
Note
|
Sample query
View the active session history of the current OBServer node in the tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_ACTIVE_SESSION_HISTORY LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
SAMPLE_ID: 1923642
SAMPLE_TIME: 2025-03-04 10:56:11.514023
CON_ID: 1002
USER_ID: 0
SESSION_ID: -9223372036854729604
SESSION_TYPE: BACKGROUND
SESSION_STATE: ON CPU
SQL_ID: NULL
PLAN_ID: 0
TRACE_ID: NULL
EVENT:
EVENT_NO: 0
EVENT_ID: NULL
P1TEXT:
P1: 0
P2TEXT:
P2: 0
P3TEXT:
P3: 0
WAIT_CLASS: OTHER
WAIT_CLASS_ID: 100
TIME_WAITED: 0
SQL_PLAN_LINE_ID: NULL
GROUP_ID: 0
PLAN_HASH: NULL
THREAD_ID: 82045
STMT_TYPE: NULL
TIME_MODEL: 0
IN_PARSE: N
IN_PL_PARSE: N
IN_PLAN_CACHE: N
IN_SQL_OPTIMIZE: N
IN_SQL_EXECUTION: N
IN_PX_EXECUTION: N
IN_SEQUENCE_LOAD: N
IN_COMMITTING: N
IN_STORAGE_READ: N
IN_STORAGE_WRITE: N
IN_REMOTE_DAS_EXECUTION: N
IN_FILTER_ROWS: N
IN_RPC_ENCODE: N
IN_RPC_DECODE: N
IN_CONNECTION_MGR: N
PROGRAM: T1002_LogService
MODULE: LogRestoreService
ACTION: RemoteLogWriter
CLIENT_ID: NULL
BACKTRACE: NULL
TM_DELTA_TIME: 1017261
TM_DELTA_CPU_TIME: 1017261
TM_DELTA_DB_TIME: 1017261
TOP_LEVEL_SQL_ID: NULL
IN_PLSQL_COMPILATION: N
IN_PLSQL_EXECUTION: N
PLSQL_ENTRY_OBJECT_ID: NULL
PLSQL_ENTRY_SUBPROGRAM_ID: NULL
PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
PLSQL_OBJECT_ID: NULL
PLSQL_SUBPROGRAM_ID: NULL
PLSQL_SUBPROGRAM_NAME: NULL
BLOCKING_SESSION_ID: NULL
TABLET_ID: NULL
PROXY_SID: -9223372036854729604
TX_ID: NULL
DELTA_READ_IO_REQUESTS: 0
DELTA_READ_IO_BYTES: 0
DELTA_WRITE_IO_REQUESTS: 0
DELTA_WRITE_IO_BYTES: 0
1 row in set (0.018 sec)